Postgres Pro
Downloads
Home   >   mailing lists

Thread: Need followup setup instructions to postgresql-10.3-1-linux-x64.run

Need followup setup instructions to postgresql-10.3-1-linux-x64.run

From
Sherman Willden
Date:
Name: Sherman
Platform: HP Compaq 6710b
Operating System: Ubuntu 17.10 Fresh Install
postgresql: 10 Fresh Install. No other versions

What post-setup must I perform to get postgresql 10 running.

I used postgresql-10.3-1-linux-x64.run which ran great. It place postgresql in /opt/PostgreSql. I am logged in as sql-dev the user I created when installing Ubuntu.

Now I can't even recognize postgres. postgres has a system password and sql-dev has a system password. I have to run all commands from /opt/PostgreSQL/10/bin or such. postgres receives a password authentication failed for user "postgres". Also for "sql-dev".

I have postgresql-10-A4.pdf but I haven't recognized what I need there yet.

Thank you;

Sherman

Re: Need followup setup instructions topostgresql-10.3-1-linux-x64.run

From
pinker
Date:
you probably need to change pg_hba.conf. set the authentication method to
trust for your user, reload the server with pg_ctl, go to psql and change
the passwords. more details you will find here:

https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html