-----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@LinuxNinja.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-----
