HOW-TO migrate database

From: "Marian Sabo" <sabo(at)cps(dot)sk>
To: pgsql-admin(at)postgresql(dot)org
Subject: HOW-TO migrate database
Date: 2001-07-17 08:05:02
Message-ID: 9j0rkk$1ugo$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello

I have a many databases on server "one" in postgres-6.5.2

How can I copy my databases to a new server with new postgres vsersion
(7.1.2) ?

on first server I run : pg_dumpall -o > outputfile, but on new server
pg_restore don't understand the data format.

the same result is on pg_dump dbname > file and on second server pg_restore
file ...

How it is possible to copy all databases from one (6.5.2) to second (7.1.2)
server ?

Many thanks

Marian Sabo

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dalibor Andzakovic 2001-07-17 09:41:20 rserv
Previous Message Rommel B. Abaya 2001-07-17 00:54:20 Re: how to connect remote database