|
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
|
