On 23 October 2012 10:15, Craig Ringer wrote:
>
> First, try per-database dumps. Work out which database has the problem.
> Do a:
>
> pg_dumpall -U sns84 --globals-only > globals.sql
>
> then for each database:
>
> pg_dump -U sns84 -f $dbname.sql $dbname
>
> (scripting it if desired),
On 10/22/2012 03:24 AM, Terry Khatri wrote:
> Hi
>
> I am getting the following error msg when I do a pg_dumpall
>
> -
>
> TK@OraLinux /usr/local/pgsql/backups
> $ pg_dumpall -U sns84 > completebackup20121020,sql
> pg_dump: schema with OID 74363 does not exist
> pg_dumpall: pg_dump failed on
Hi
I am getting the following error msg when I do a pg_dumpall
-
TK@OraLinux /usr/local/pgsql/backups
$ pg_dumpall -U sns84 > completebackup20121020,sql
pg_dump: schema with OID 74363 does not exist
pg_dumpall: pg_dump failed on database "bihistory", exiting
-
I have set the logs to de
This turned out to be a wrapper versus binary issue. psql was
running under the wrapper. It ran fine. pg_dump wasn't but when we
corrected this it worked fine too.
This is the first time I've run into this and it's the first time
I've dealt with PostgreSQL on any but a Sparc running Solari
Hi
> "CW" == Carol Walter <[EMAIL PROTECTED]> writes:
CW> [EMAIL PROTECTED]:~$ /usr/local/pgsql/bin/pg_dumpall pg_dumpall:
CW> could not connect to database "template1": could not connect to
CW> server: No such file or directory Is the server running locally
CW> and accepting connections on U
Carol Walter <[EMAIL PROTECTED]> writes:
> I'm having a problem that I hope you can help me with. I am getting
> the following error when I try to run pg_dumpall.
> [EMAIL PROTECTED]:~$ /usr/local/pgsql/bin/pg_dumpall
> pg_dumpall: could not connect to database "template1": could not
> connec
Greetings,
I'm having a problem that I hope you can help me with. I am getting
the following error when I try to run pg_dumpall.
[EMAIL PROTECTED]:~$ /usr/local/pgsql/bin/pg_dumpall
pg_dumpall: could not connect to database "template1": could not
connect to server: No such file or director