psql from Linux script
| От | Bernard |
|---|---|
| Тема | psql from Linux script |
| Дата | |
| Msg-id | 4h08h1dcq5i2tdlqmv9osaog00chkljs6r@4ax.com обсуждение исходный текст |
| Ответы |
Re: psql from Linux script
Re: psql from Linux script |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: