Re: Not Finding password for Postgres user on Linux

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Nandu Garg <focussed(at)rediffmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Not Finding password for Postgres user on Linux
Date: 2002-01-24 15:41:42
Message-ID: 3C502B36.B4EA0887@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> However again it asks me to get connected to Postgres user for Linux.

If you installed from RPMs, then the *system* account for the Postgres
user has a disabled password by default. You will need to ask your
sysadmin to set the password for you before you can log in to that
account (unless you su to that account via the root account first; I
gather that you do not have root privs on that machine).

> Now I have gone through installations and nowhere I found any default
> password for postgres user.

There are two possible accounts (and passwords) to consider, and your
description has left us confused over which you are asking about. You
will need to set a password for the system account, as mentioned above,
and as others have mentioned the *PostgreSQL* account for the Postgres
user has an empty password by default.

Once you have created another user in the database, say "amol", with
full privileges you will find that you do not need to be the Postgres
user very often.

hth

- Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nic Ferrier 2002-01-24 16:00:06 Can I use PG_FUNCTION_INFO_V1 in C++
Previous Message Justin Clift 2002-01-24 15:31:59 Re: Problems with initdb on Cygwin