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-----
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 |