[ADMIN] Recovery using Online Backup+WAL and broken passwords

2005-02-04 Thread Michael Klatt
PostgreSQL 8.0.1 Linux FC2, 2.6.8 Hi, I'm very new to PostgreSQL. I've been the admin of several MySQL servers for years, but for various reasons we're switching to PostgreSQL. I love the online backup feature, but I'm encountering a problem with users restored from WAL files. It seems that af

Re: [ADMIN] Recovery using Online Backup+WAL and broken passwords

2005-02-04 Thread Michael Klatt
Tom Lane wrote: [ thinks about that... ] Hmm, you're right, there is no mechanism to cause the flat password file to be rebuilt after a restore. So newly created users won't be in it (and for that matter it won't reflect post-backup password changes for existing users). Just (re)assign any one u

Re: [ADMIN] Recovery using Online Backup+WAL and broken passwords

2005-02-07 Thread Michael Klatt
Tom Lane wrote: > [ thinks about that... ] Hmm, you're right, there is no mechanism to cause the flat password file to be rebuilt after a restore. So newly created users won't be in it (and for that matter it won't reflect post-backup password changes for existing users). Just (re)assign any on

Re: [ADMIN] replication

2005-02-14 Thread Michael Klatt
Christopher Browne wrote: The world rejoiced as [EMAIL PROTECTED] (Fred Blaise) wrote: Hello I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one is a failover. I would like to implement a master-slave replication process. I believe replication has been included in the base packa