On Fri, Aug 21, 2009 at 10:46 AM, james bardin wrote:
> The first move runs easily as expected- postgres ships the last
> partial wal immediately on shutdown, trigger the standby and we're up.
> I'm now running into issues bringing the first server back up in
> standby mode. After the second serve
Pablo Alonso-Villaverde Roza writes:
> I'm getting duplicated rows in some of my tables when I try to restore data
> from a dump file generated with 'pg_dumpall'.
Probably all of them, actually ...
> The only "way" I have found to solve this problem is deleting my database
> before restoring the
Scott Marlowe wrote:
On Fri, Aug 21, 2009 at 11:42 AM, Geoffrey wrote:
We have a two node cluster and we are planning on adding a third.
P.s. what do you mean by two node cluster? What software are you
using to do this?
Red Hat clustering suite. The machines are accessing the data on a
c
Hi all,
I'm getting duplicated rows in some of my tables when I try to restore data
from a dump file generated with 'pg_dumpall'.
I use:
pg_dumpall -c -U postgres > mybackup.sql
to dump all the data, roles, etc. into a file.
Then I try to restore the data using:
psql -U postgres -f mybackup
