RE: Copy

Поиск
Список
Период
Сортировка
От Sokel, John
Тема RE: Copy
Дата
Msg-id CAD59D8EA8B7124894637FC44951789F49703E@scratchy.int.mdsi-usa.com
обсуждение исходный текст
Ответ на Copy  (syed asghar <abemail1@yahoo.co.uk>)
Список pgsql-novice

I am assuming you know how to set up Postgres and get it running.  If that is the case, then all you have to do is a pg_dumpall to get your data in an external file.  FTP that file to the new machine, and then reimport it with psql. 

John

-----Original Message-----
From: syed asghar [mailto:abemail1@yahoo.co.uk]
Sent: Monday, September 11, 2000 8:55 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Copy

Hi there people.

I must warn you, I really am a novice - anyway my
problem is:

I have a postgres database on one server and I need to
move it with its contents to another server.

Should I go into the database and run some command to
do this.

Does anyone have instructions about how to get it from
one server the other server with data and get it
functional?

Any help would be apreciated.

Thanks.

____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Sokel, John"
Дата:
Сообщение: RE: Removing all NOT NULL constraints from multiple tabl es easily
Следующее
От: "Dan Browning"
Дата:
Сообщение: cat infile | translate all occurences of "NOT NULL" to ""