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
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),
Somebody PLEASE HELP ! is Tome Lane around !
Tks
T
-- Forwarded message --
From: Terry Khatri
Date: 22 October 2012 00:20
Subject: Errors on pg_dumpall
To: pgsql-admin-ow...@postgresql.org
Hi
I am getting the following error msg when I do a pg_dumpall
-
TK@OraLinux /usr
| 10 | {sns84=UC/sns84,=UC/sns84}
11459 | information_schema | 10 | {sns84=UC/sns84,=U/sns84}
82537 | world | 10 |
(7 rows)
What I should do next ?
Please help
Thanks
T
On 5 November 2012 14:09, Lukasz Brodziak wrote:
> 2012/11/3 Craig Ringer :
> > On 11/01/2012 10:05 PM, Ter
Hi
When I tried to take a base backup of the master database I go the
following message:
$ pg_basebackup.exe -U sns84 -h 192.168.56.10 -D ccslave
pg_basebackup: directory "/usr/local/pgsql/master/pg_tblspc" exists but is
not empty
Any I idea how I can fix it - please help
Thanks
T
On 5 November 2012 22:05, Lukasz Brodziak wrote:
> 2012/11/5 Terry Khatri :
> > Hi
> >
> > When I tried to take a base backup of the master database I go the
> following
> > message:
> >
> >
> >
> > $ pg_basebackup. -U sns84 -h 192.168.5
Hello
I need to do the subject setup using PostgreSQL, where when one node goes
down another takes over without manual intervention, the way it is done in
Oracle using grid infrastructure and in SQL Server 2012 using their
Alway-On feature
My question is, has anyone done that ? can anyone please
-02 at 01:45 +0500, Terry Khatri wrote:
> >
> > I need to do the subject setup using PostgreSQL, where when one node
> > goes down another takes over without manual intervention, the way it
> > is done in Oracle using grid infrastructure and in SQL Server 2012
> > using t
December 2012 21:00, Devrim GÜNDÜZ wrote:
>
>
> On Sun, 2012-12-16 at 03:25 +0500, Terry Khatri wrote:
>
>
> > I am having an issue with postgres service on redhat cluster suite
> > (Rehl6), the service gets started on 2 nodes out of 3, is that the
> > right behavi
