Thanks Tom and Paul for your advice. -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Tom Lane Sent: Friday, 2 December 2005 2:40 AM To: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] old database dump. Paul Breen <paul.breen6@xxxxxxxxxxxxxx> 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. ______________________________________________________________________________