Hello all!
I would like to ask what would be the best procedure to upgrade to a
new version of PostgreSQL in a production system when there is a 'initdb'
necessary?
Situation:
We are running PostgreSQL in a production system. There are about 1000
selects and about 100 inserts per minute.
To u
I'm trying to setup PAM authentication for PostgreSQL. I compiled with PAM
and configured pg_hba.conf:
host test10.3.62.251 255.255.255.255pam
When I try to connect I get:
psql: FATAL 1: PAM authentication failed for user "postgres"
The log shows:
CheckPAMAuth: pam_authent
Vincent Janelle wrote:
> No. Only one postmaster can access the PGDATA dir at one time.
> Attempting to run multiple copies will result in data corruption.
We also don't recommend NFS directories because the NFS file behavior is
not 100% the same as a local file system.
--
Bruce Momjian
I don't have any good news for you. Yes, you can set up a server on a
different port and perform a dump and reload while both systems are up,
but as you say, you are going to miss inserts during the dump because
pg_dump takes a snapshot when it starts.
My only suggestion is to keep the old data
hello,
if anyone has experience with dbmirror.pl please advise:
I am installing dbmirror (from contrib tree): I compiled it under
the source tree of postgresql-7.3b2 and everything went fine:
since I need to test it on a postgres-7.1.3 installation (which does not
include dbmirror) I then copie
On 10 Oct 2002 at 9:46, Reiner Dassing wrote:
> To upgrade to PostgreSQL 7.2.3 there is an 'initdb' necessary.
This caused me to ask around off-list. An initdb is required only if
you are upgrading from from pre-7.2.X.
--
Dan Langille
I'm looking for a computer job:
http://www.freebsddiary.or
On Tue, 2002-10-08 at 12:21, Johnson, Shaunn wrote:
> Not sure if this the most likely of maillists to ask,
> but is anyone using phpPgAdmin? I have a few questions
> regarding authentication of username / passwords.
We are. I love it.
> In my pg_hba.conf, I have this:
>
> [snip conf file]
>
