Thread: psql : password on Win32

psql : password on Win32

From

"Fabio D'Ovidio"

Date:

26 February 2007, 18:04:26

Hi folks !
I am new of the list even if I use PostgreSQL\PostGIS since I was in Planetek to work.

I have a problem with psql  command line on Windows XP. I want to set password for the
user postgres in order to execute an sql script directly from a batch file without entering
password from the prompt.

The command is :

psql -U postgres -d mydb -f script.sql

I have used pgpass.conf file with the syntax :

localhost:5432:mydb:postgres:password

and it doesn't work.

How can i do ?

Thanks!

--
Fabio D'Ovidio

Web GIS Staff
Planetek Italia s.r.l.
Via Massaua 12, I-70123 Bari
Tel.: +39 080 5343750 Fax: +39 080 5340280
dovidio@planetek.it - http://www.planetek.it
--

Re: psql : password on Win32

From

"A. Kretschmer"

Date:

26 February 2007, 18:20:21

am  Mon, dem 26.02.2007, um 19:34:25 +0100 mailte Fabio D'Ovidio folgendes:
> I have used pgpass.conf file with the syntax :
>
> localhost:5432:mydb:postgres:password
>
> and it doesn't work.

Wrong syntax. Change ':' to '\t' or other whitespace.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net