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