On Tue, Nov 26, 2013 at 10:11 PM, Bob Doolittle wrote:
On 11/26/2013 03:27 PM, Dafna Ron wrote:
>
> sql -U postgres engine -c 'select connection from
> storage_server_connections;'
I guess you mean psql. But I keep getting an authentication error. I don't
see any obvious passwords in the postgresql.conf file, nor in my
setup/install logs. Is there a hardcoded password somewhere?
I've tried different users - admin, postgres, engine, and I've tried all of
those with the admin password I specified during setup. No dice.
As a workaroud possibly:
- establish an ssh connection as root with the engine server
- switch to postgres user
[root@f18engine ~]# su - postgres
- connect to engine database
-bash-4.2$ psql engine
psql (9.2.5)
Type "help" for help.
- execute the query
engine=# select connection from storage_server_connections;
connection
-----------------------------------------------
f18engine.mydomain:/var/lib/exports/iso
f18ovn01.mydomain:gvdata
(2 rows)
It work for me with 3.3.1 on f19