Re: old database dump.

From: "Theo Galanakis" <t(dot)galanakis(at)mbs(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: old database dump.
Date: 2005-12-01 22:19:20
Message-ID: 11C75E9645FB0F428EFA37F5BEADFEA1011C4145@CAR-MBUS-MX1.mbus.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks Tom and Paul for your advice.

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Friday, 2 December 2005 2:40 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] old database dump.

Paul Breen <paul(dot)breen6(at)btinternet(dot)com> writes:
> Alternatively you can login with your password as
> normal and then once in psql use the '\i filename'
> command to read in your backup.

Or use "psql -f file" instead of "psql < file".

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

--
_______________________________________________________________________________

Notice from Melbourne Business School Ltd

The information contained in this e-mail is confidential, and is intended for
the named person's use only. It may contain proprietary or legally privileged
information. If you have received this email in error, please notify the
sender and delete it immediately. You must not, directly or indirectly, use,
disclose, distribute, print, or copy any part of this message if you are not
the intended recipient

Internet communications are not secure. You should scan this message and any
attachments for viruses. Melbourne Business School does not accept any
liability for loss or damage which may result from receipt of this message or
any attachments.

______________________________________________________________________________

Browse pgsql-admin by date

  From Date Subject
Next Message Guido Barosio 2005-12-01 22:41:30 Re: reg:large object OID
Previous Message Joshua D. Drake 2005-12-01 15:52:53 Re: --with-perl