Hi,
Ignore this error. I did not create a superuser. That fixed the
problem.
Shahryar
From: Shahryar G. Hashemi
Sent: Monday, January 08, 2007 8:19 PM
To: 'pgsql-admin@postgresql.org'
Subject: ERROR: permission denied for language c
Hi,
I hav
Hi,
I have created a new user called hydra with 'createdb' permission. I
can create the DB but when I run this command I get this error. I did
the GRANT USAGE for LANGUAGE C to hydra. But still the error. Any
ideas?
hydra=> CREATE FUNCTION plpgsql_call_handler() RETURNS
language
"Chris Hoover" <[EMAIL PROTECTED]> writes:
> Over the weekend, I suffered from major database corruption on my
> 8.1.3database. Fortunetly, this was my development/non-production box
> so I did
> not have to spend my entire weekend getting it back online, but I did spend
> a major portion of it.
Over the weekend, I suffered from major database corruption on my
8.1.3database. Fortunetly, this was my development/non-production box
so I did
not have to spend my entire weekend getting it back online, but I did spend
a major portion of it. I ended up having to do a pitr recovery of the
syste
On Mon, 2007-01-08 at 09:41 -0600, Ben K. wrote:
> > On Fri, 2007-01-05 at 12:59 -0600, Ben K. wrote:
> >> 2. sql dump and PITR
> >> Is it possible to use the PITR method with SQL dump? (pg_start_backup ->
> >> sql dump -> pg_stop_backup) I guess not, but just want to make sure.
> >
> > No, because
On Fri, 2007-01-05 at 12:59 -0600, Ben K. wrote:
2. sql dump and PITR
Is it possible to use the PITR method with SQL dump? (pg_start_backup ->
sql dump -> pg_stop_backup) I guess not, but just want to make sure.
No, because there is no reason or benefit.
Thanks. I guess the PITR plays on a di
"Alagarsamy Manimaran-FDRP63" <[EMAIL PROTECTED]> writes:
> I am running Postgres 8.0. How can I get the parameter values printed in
> the log for a prepared statement?
Update to 8.2.
regards, tom lane
---(end of broadcast)-
Hi all,
I have to restore a database that its dump using custom format (-Fc)
takes about 2.3GB. To speed the restore first I have restored everything
except (played with pg_restore -l) the contents of some tables that's
where most of the data is stored.
I think you've outsmarted yourself
