Use the .pgpass file.
On Thu, 1 Dec 2005, Theo Galanakis wrote:
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
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.fro
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
Many thanks, Peter and Bricklen. That worked well.
---
Husam Tomeh
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 30, 2005 6:46 AM
To: Tomeh, Husam
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] upgrade database to 8.1 - 2GB file
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> I have never figured out what the FSM numbers printed by VACUUM VERBOSE
> really
> meant. I have for example,
> INFO: free space map: 101 relations, 150 pages stored; 1664 total pages
> needed
> What exactly does that last number mean? I have 200
I have never figured out what the FSM numbers printed by VACUUM VERBOSE really
meant. I have for example,
INFO: free space map: 101 relations, 150 pages stored; 1664 total pages
needed
What exactly does that last number mean? I have 2 pages configured for
the FSM, so if it needs 1664, w
Tomeh, Husam wrote:
I'm upgrading from 8.0 to 8.1 on RedHat 2.6 kernel. I'm hitting the file
max limit of 2 GB file when I pg_dump my database (even if I compress
the dump file as it gets generated using a pipe). pg_dump is the
recommendation stated in the INSTALL doc to upgrade; what would be
Am Mittwoch, 30. November 2005 15:17 schrieb Tomeh, Husam:
> I'm upgrading from 8.0 to 8.1 on RedHat 2.6 kernel. I'm hitting the file
> max limit of 2 GB file when I pg_dump my database (even if I compress
> the dump file as it gets generated using a pipe). pg_dump is the
> recommendation stated in
I'm upgrading from 8.0 to 8.1 on RedHat 2.6 kernel. I'm hitting the file
max limit of 2 GB file when I pg_dump my database (even if I compress
the dump file as it gets generated using a pipe). pg_dump is the
recommendation stated in the INSTALL doc to upgrade; what would be the
next recommendatio
