Not Finding password for Postgres user on linux

Thursday, January 24, 2002, 9:13:22 AM, Nandu Garg wrote:

Hi All

I have just now got the Postgresql installed again. But again before connecting it it requires me to connect to Postgres user. Now how could I get connected. There is nothing mentioned in Postgre
documentation about the default password. Is the password allocated dynamically?
My linux administrator says he could not find the password. Do I have to create a new user where it's group is pg_database or what?

Take a look at data/pg_hba.conf file.
By default postgres allow connect without password for user 'postgres'
so you can type: psql -U postgres template1

--
Dimitry

Hi

I am connected to Linux $ prompt with user 'amol' which has Oracle DBA privileges. When I try to connect using
$su postgres It prompts me for the password (which I donno) and when I issue $psql -U postgres Template1
I give me 'psql: invalid option -- U'
Therefore I tried small u i.e. I issued the command
'$psql -u postgres template1' It prompted me like this
Username: postgres
Password:

Connection to database 'postgres' failed.
FATAL 1: Database postgres does not exist in pg_database

When It asked me for username I entered 'postgres' as username and password I kept empty but still it gave me above error messge. I donno how suddenly it said 'database postgres ' does not exists because I entered postgres as username.

Amol

On Thu, 24 Jan 2002 Dmitry Alyabyev wrote :

Hi all

Just now I tried following

$psql -u template1
Username: postgres
Password:

Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: template1

template1=>

Amol

On Thu, 24 Jan 2002 Dmitry Alyabyev wrote :

On Thu, Jan 24, 2002 at 09:27:15AM -0000, Nandu Garg wrote:

I give me 'psql: invalid option -- U'

You have an old version of psql.

Therefore I tried small u i.e. I issued the command
'$psql -u postgres template1' It prompted me like this

This old version requires: $psql -u template1

Please read the manpage of psql. The command line options of psql are
explained there in detail !

--
Holger Krug
hkrug@rationalizer.com

Hi Amol,

PLEASE upgrade to PostgreSQL 7+ ! The latest production-quality release
of PostgreSQL is 7.1.3, and if you've got a choice, that's your best
one. :)

Versions of PostgreSQL older than version 7.x (you're running version
6.5.3) have some pretty nasty bugs in them, and because they're so old
we have difficulty in offering much in the way of assistance when you
have a problem. :(

If you can upgrade, it'll give you a better (faster, more stable, more
powerful SQL capabilities, better crash recovery (if it ever crashes))
database, and it's also easier to tune for better performance.

Hope this helps.

:-)

Regards and best wishes,

Justin Clift

Nandu Garg wrote:

Hi all

Just now I tried following

$psql -u template1
Username: postgres
Password:

Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: template1

template1=>

Amol

On Thu, 24 Jan 2002 Dmitry Alyabyev wrote :

Thursday, January 24, 2002, 9:13:22 AM, Nandu Garg
wrote:

Hi All

I have just now got the Postgresql installed again.

But again before connecting it it requires me to
connect to Postgres user. Now how could I get
connected. There is nothing mentioned in Postgre

documentation about the default password. Is the

password allocated dynamically?

My linux administrator says he could not find the

password. Do I have to create a new user where it's
group is pg_database or what?

Take a look at data/pg_hba.conf file.
By default postgres allow connect without password for
user 'postgres'
so you can type: psql -U postgres template1

--
Dimitry

---------------------------(end of broadcast)
---------------------------
TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi