Re: psql from Linux script - Mailing list pgsql-general

From Patrick.FICHE@AQSACOM.COM
Subject Re: psql from Linux script
Date
Msg-id 1DC6C8C88D09D51181A40002A5286929B2369F@intranet
Whole thread Raw
In response to psql from Linux script  (Bernard <bht@actrix.gen.nz>)
List pgsql-general
Hi Bernard,

I just ran a test on Solaris...
The following syntax is working for me :

su - postgres -c "psql template1 -U postgres -c \"ALTER USER postgres WITH
PASSWORD 'newpassword';\""

If it can help you...

----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick.fiche@aqsacom.com
tel : 01 69 29 36 18
----------------------------------------------------------------------------
---------------




-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Bernard
Sent: mardi 30 aout 2005 09:05
To: pgsql-general@postgresql.org
Subject: [GENERAL] psql from Linux script


Dear Postgresql Specialists

I am failing to update the password of the postgresql user from within
a Linux installation script run by root:

# su - postgres -c echo "ALTER USER postgres WITH PASSWORD
'newpassword';" | psql -U postgres template1
psql: FATAL:  Ident authentication failed for user "postgres"

In contrast, there is no problem with the same command issued in psql
interactively:

# su postgres
$ psql template1
template1=# ALTER USER postgres WITH PASSWORD 'newpassword';
ALTER USER
\q
$ exit
#

The client authentication configuration file pg_hba.conf is in its
original state.

I would appreciate your help very much.

Thanks.

Bernard

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

pgsql-general by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: psql from Linux script
Next
From: Bernard
Date:
Subject: Re: psql from Linux script