Обсуждение: Re: Postgresql pg_dumpall

Поиск
Список
Период
Сортировка

Re: Postgresql pg_dumpall

От
"Peter Koczan"
Дата:
Hi Suresh, you should Cc: pgsql-admin@postgresql.org in case I don't know or someone else can help you sooner.

I am using on prod server with psql version : psql 7.4.2

In another test server the version of psql is : Portions Copyright (c) 1996-2003, (could not get version)

You should figure out what version you're running. You can run psql --version in a terminal to figure that out. Make sure you're running the latest revision of whatever major version you choose ( 8.2.5, for instance).

I could run this command on test server but couldn't run on prod server. May I have some help? Where commercelink is my database name. We use to enter into database like this "psql commercelink".

pg_dumpall dumps an entire database cluster, not just a database. Either omit the database name or use pg_dump instead of pg_dumpall.

Peter