Mauri Sahlberg <Mauri(dot)Sahlberg(at)claymountain(dot)com> writes:
> What if I just wish to move a single database with it's users to a new
> machine? It would be a disaster to overwrite whole existing system
> catalog on the target machine.
Users (and groups) are global across each Postgres installation.
So what you'd need to do is something like this:
pg_dump the desired database, and do "pg_dumpall -g" to get a script
recreating all your users and groups. Edit out the non-pertinent
part of that script. Run the users/groups script and then the pg_dump
script on the target machine.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: sv||Date: 2005-05-02 02:13:39|
|Subject: Getting Started Basic Admin |
|Previous:||From: Tom Lane||Date: 2005-04-30 16:19:30|
|Subject: Re: Unable to drop index |