old database dump.

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

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.

______________________________________________________________________________

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2005-12-01 06:57:46 Re: old database dump.
Previous Message Tomeh, Husam 2005-12-01 01:33:19 Re: upgrade database to 8.1 - 2GB file limit (pg_dump)