for it.
Yauheni Labko (Eugene Lobko)
Junior System Administrator
Chapdelaine Co.
(212)208-9150
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
think you have problem at this point. Did you switch primary database server
into backup mode? Where are the archived WAL files? Did you switch primary
database server back into normal operation mode after rsyncing?
Yauheni Labko (Eugene Lobko)
Junior System Administrator
Chapdelaine Co.
(212)208
For some reason it is looking for 0002001C.00512178.backup
file which is not the WAL file.
Are you sure that you made initial recovery properly?
Yauheni Labko (Eugene Lobko)
Junior System Administrator
Chapdelaine Co.
(212)208-9150
On Wednesday 04 March 2009 03:14:51 pm Ray
.
What is the archive_command for primary server?
Yauheni Labko (Eugene Lobko)
Junior System Administrator
Chapdelaine Co.
(212)208-9150
On Wednesday 04 March 2009 04:35:00 pm you wrote:
On Wed, Mar 04, 2009 at 03:41:06PM -0500, Yauheni Labko wrote:
For some reason it is looking
Btw i think you may remove %r from the restore command.
Yauheni Labko (Eugene Lobko)
Junior System Administrator
Chapdelaine Co.
(212)208-9150
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Is there a method to dump just the roles from a database, or otherwise
select them, so I can build a script to reload the roles? Otherwise, I
guess I'll just read the tables for each database and build the
security script from that.
from man pg_dumpall:
-r
--roles-only
Dump