Re: [GENERAL] dumping and restoring user information.

2005-02-03 Thread Pritesh Shah
Thanks, it worked. On Tue, 1 Feb 2005 00:30:31 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Tue, Feb 01, 2005 at 12:11:06AM -0700, Pritesh Shah wrote: > > > > Is there any way of copying/dumping/restoring the user and group > > information and permissions from the old machine to the new on

Re: [GENERAL] dumping and restoring user information.

2005-01-31 Thread Michael Fuhr
On Tue, Feb 01, 2005 at 12:11:06AM -0700, Pritesh Shah wrote: > > Is there any way of copying/dumping/restoring the user and group > information and permissions from the old machine to the new one so > that i do not have to do a createuser everytime?? You can dump just users and groups with "pg_du

[GENERAL] dumping and restoring user information.

2005-01-31 Thread Pritesh Shah
hi, I'm trying to make some hardware upgrades (increasing disk capacity) to the machine where the database server is running. So, I've backed up all the existing databases using the following command: pg_dump -f -Fc -v I want to restore these databases on a different machine. I've got the post