Re: Authorization,Authentication issues trying basic commands.

On 22/05/13 14:15, luis redondo wrote:
> It's my first time using PostgreSQL and I need to do basic things as
> establishing a new user,create a new database,access psql command line
> client etc.
>
> I tried : su - postgres to access the server but I don't have a valid
> password,I don't know if the server is requesting the postgres system
> account password,or the database one.
>
> I installed PGSQL that come with Oracle Linux 6.4 and don't know what
> is the PGSQL default configuration.
>
> Basically,I start the server with: /etc/init.d/postgresql start ,and I
> am stuck about what to do next,and with permissions,authentications etc.
>
> Note: I changed in pg_hba.conf authorizations (ident to trust) but
> still no access to a workable PGSQL
> account.
>
If you
_*su -*_
to root, then from there you can
_*su - postgress*_
without requiring a password, as root is 'god'!

Cheers,
Gavin