Pascal Van Puymbroeck wrote:
> I'm not sure if this is the best method but I use the:
>
> pgsql -d dbase -U ppk -f e:\\Test.imp < passwd.txt
>
> Where passwd.txt holds the password for the user specified.
Also see .pgpass in the libpq manual section. It allows you to store
passwords in a file f
I'm not sure if this is the best method but I use the:
pgsql -d dbase -U ppk -f e:\\Test.imp < passwd.txt
Where passwd.txt holds the password for the user specified.
Hope this helps you out.
Pascal Van Puymbroeck
ZENON productions bvba
---(end of broadcast)--
On Feb 8, 2005, at 3:11 AM, Andrei Bintintan wrote:
I have to run some command line commands that I have to run on a
windows machine. Like pgsql, dropdb, createdb etc.
All these commands are runned from a php scripts.
Now, my question is how can I specify a User and Password to
postgresql dat
> This might not apply to the win32 version. But in the Unix
> version you can put this information in a .pgpass file. This
> enables you to keep passwords on all user accounts and still
> be able to automate tasks.
It applies to win32 as well, only the file is called "pgpass.conf", see
http://w
t;[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
Sent: Tuesday, February 08, 2005 6:36 PM
Subject: Re: [ADMIN] Win32 Postgresql Command Line Password
This might not apply to the win32 version. But in the Unix version you
can
put this information in a .pgpass file. This enables you to keep
passwords
(at least upto 7.4.6 - I don't know
about
later versions) thereis no way to specify the password on the
commandline.
Regards
Iain
- Original Message -
From: Andrei Bintintan
To: pgsql-admin@postgresql.org
Sent: Tuesday, February 08, 2005 5:11 PM
Subject: [ADMIN] Win32 Postg
Not sure if it will work in windows, but in unix, I use the envrionmental
variable PGPASSWORD
Not the safest thing in the world, but in my case, if a hacker's gotten through
two layers of firewall, I'm sunk anyhow. :)
Andrei Bintintan wrote:
Hi,
I have to run some command line commands that I h
it is (at least
upto 7.4.6 - I don't know about later versions) thereis no way to specify the
password on the commandline.
Regards
Iain
- Original Message -
From:
Andrei
Bintintan
To: pgsql-admin@postgresql.org
Sent: Tuesday, February 08, 2005
5:11 PM
Subject: [ADM
Hi,
I have to run some command line commands that I
have to run on a windows machine. Like pgsql, dropdb, createdb etc.
All these commands are runned from a php scripts.
Now, my question is how can I specify a User and
Password to postgresql database system. I found out how can I say
