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
-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
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
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
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
| 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
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
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),
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
