Database access error after upgrade 7.1.2 -> 7.1.3

From: Steve Frampton <frampton(at)LinuxNinja(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Database access error after upgrade 7.1.2 -> 7.1.3
Date: 2001-10-10 08:42:19
Message-ID: Pine.LNX.4.33.0110100434000.14259-100000@astro.phpwebhosting.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello:

I just moved a database server from 7.1.2 to 7.1.3. After looking in the
ChangeLog and not seeing anything that would seem to indicate any DB
structural changes, I did the upgrade as follows:

pg_ctl stop -D /home2/pgsql/data -w -m smart
mv /home2/pgsql /home2/pgsql-7.1.2
mkdir /home2/pgsql && cd /home2/pgsql && cp -R /home2/pgsql/data &&
chown postgres:postgres data

(Built and installed 7.1.3)

/home2/pgsql/bin/postmaster -D /home2/pgsql/data -i &

No errors were reported, and I can access my user created databases.
However, if I try to connect to template0, I get the following error
message:

psql: FATAL 1: Database "template0" is not currently accepting
connections

(Again, user created databases, as well as template1, can be accessed
normally.)

Is there a solution for this? If not, my boss is wondering if suicide is
a viable alternative.

Thanks...

- ---------------< LINUX: The choice of a GNU generation. >-------------
Steve Frampton <frampton(at)LinuxNinja(dot)com> http://www.LinuxNinja.com
GNU Privacy Guard ID: D055EBC5 (see http://www.gnupg.org for details)
GNU-PG Fingerprint: EEFB F03D 29B6 07E8 AF73 EF6A 9A72 F1F5 D055 EBC5
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.0 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7xAnvmnLx9dBV68URAgHvAJ4iowIin8sz4n6WhTtWcTHWdpHLZwCfYKb/
UoXfLSLQO6FxYnzyKmPMdXI=
=HHAV
-----END PGP SIGNATURE-----

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Moovarkku Mudhalvan 2001-10-10 12:00:50 Permission Denied When i am Trying to take Backup
Previous Message Rainer Mager 2001-10-09 23:00:54 Re: Vacuum