Re: [ADMIN] Backing up users?

2005-04-30 Thread Tom Lane
Mauri Sahlberg <[EMAIL PROTECTED]> 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

Re: [ADMIN] Unable to drop index

2005-04-30 Thread Tom Lane
Oliver Duke-Williams <[EMAIL PROTECTED]> writes: > The table on which the index was built is no longer present (it should > have been dropped by my application after being used), but it would > appear that the index was not dropped at the same time as the table: That's fairly strange; it should

Re: [ADMIN] Backing up users?

2005-04-30 Thread Bruno Wolff III
On Sat, Apr 30, 2005 at 11:16:59 +0300, Mauri Sahlberg <[EMAIL PROTECTED]> wrote: > Hi, > > This might be a stupid question as it is not covered in the 7.4.7 and > probably obvious to all others. Where do the system catalogs live? How > to back them up? Should I back them up? > > The admin ma

[ADMIN] Backing up users?

2005-04-30 Thread Mauri Sahlberg
Hi, This might be a stupid question as it is not covered in the 7.4.7 and probably obvious to all others. Where do the system catalogs live? How to back them up? Should I back them up? The admin manual states that to restore a pg_dumped database you should have those users created that will hav