Обсуждение: 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