Thread: Update linux from 7.1 to 7.3 and couldn't get Psql7.0.3 back to work
%psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> It doesn't work The very first command gives me the error:
> ==========
> [root@...]# /etc/rc.d/init.d/postgresql start
>
> An old version of the database format was found.
> You need to upgrade the data format before using PostgreSQL.
> See (Your System's documentation directory)/postgresql-7.2/README.rpm-dist fo$
> more information.
> ===========
>
> It seems before that, I need to type the following as user postgres:
> =============
> The basic sequence is:
> (as user postgres):
> postgresql-dump -t /var/lib/pgsql/backup/db.bak -p /var/lib/pgsql/backup/old -d
> (you can abort the ASCII dump with 'Q', as it uses more) Then, (as user root):
> =================
>
> However, it seems there is no command postgresql-dump. I found a command
> called pg_dump in the /usr/lib/pgsql/backup directory. However when It
> substitute that for the other command, I get another error:
> =============
> bash-2.05a$ ./pg_dump -t /var/lib/pgsql/backup/db.bak -p
> /var/lib/pgsql/backup/old -d
> pg_dump: no database name specified
=============
Does any one has any clue? Any comments are greatly appriciated.
Thank you,
Xueying Ni
On Tue, Aug 06, 2002 at 09:29:13PM -0400, Rami A. Kishek wrote:
> %psql
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
I assume you're using Red Hat? I think there are different versions
of Postgres installed. You'll need to start the old postmaster,
dump, and then restore with the new postmaster. I don't know how to
do that with the RPMs, though.
A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M6K 3E3
+1 416 646 3304 x110