Hi, I have an old postgres database backed up using the psql > database.bak command, as apposed to pg_dump. The database was on a linux machine. I'm now trying to restore this db on a windows machine using pg8.0. However pg_restore cannot recognize the file and psql < database.bak prompts me for a password. How can I run the psql command without being prompted for a password. The password prompt and < command do not mix well as you are prompted for a password and then the command piped the file to the password prompt. If you know what I mean :( Is there another means of restoring this database. Theo -- _______________________________________________________________________________ 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. ______________________________________________________________________________
