What happens when you update from your data dump (pg_dumpall) that you do to backup your data? You did do a pg_dumpall before you did the update? I don't think it is required to upgrade from 7.1.2 to 7.1.3.
What happens when you run version 7.1.2 and access the data? /home2/pgsql /home2/pgsql-7.1.2/postmaster -D /home2/pgsql/data -i & This should run your old version of posgresql, then you could run pg_dump for the database ( /home2/pgsql /home2/pgsql-7.1.2/pg_dump **database here** > backup.out) and use this to populate your new setup. I see that from your startup you are not saving the output of postgres to a file so there is no way to look at the log. Ted -----Original Message----- From: Steve Frampton <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Date: Wed, 10 Oct 2001 04:42:19 -0400 (EDT) Subject: [ADMIN] Database access error after upgrade 7.1.2 -> 7.1.3 > -----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 <[EMAIL PROTECTED]> 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 > > iD8DBQE7xAnvmnLx9dBV68URAgHvAJ4iowIin8sz4n6WhTtWcTHW dpHLZwCfYKb/ > UoXfLSLQO6FxYnzyKmPMdXI= > =HHAV > -----END PGP SIGNATURE----- > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to > [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
