Re: pg_dumpall and restore

Hi Chad,

Once you have initdbed, try psql -e template1 < myfile.sql

Should work fine if your new system is about the same version as the one the
dump is coming from. Not quite sure were the lines go here. It does not touch
other dbs on new / old machine, only those in the dump, very good.

BR,

aarni

On Tuesday 27 May 2003 18:35, you wrote:
> I know that Ive seen a good article on dumping and restoring, but I cant
> find it.
>
> I am moving my database to another (hopefully faster) machine.  I have done
> a pg_dumpall -c myfile.sql and copied it to my new machine.  But now I cant
> find any docs on how to restore it.
>
> TIA
> Chad
>
> p.s.  Is the content management software that justin talks about @
> techdocs.postgresql.org supposed to help manage all the documentation?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

--
Aarni Ruuhimäki
Megative Tmi
KYMI.com

Pääsintie 26
45100 Kouvola

info@kymi.com / aarni.ruuhimaki@kymi.com

05 - 3755 035 / 050 - 4910 037
-------------------------------
Linux RedHat 7.3. / KDE 3.0
-------------------------------