Re: [GENERAL] Lost password

2008-12-18 Thread Johan Nel
Martin, You need to find the file pg_hba.conf. Inside of it find the lines showing: # IPv4 local connections: hostall all 127.0.0.1/32 md5 Change the md5 to trust, make sure it is only for local host that you do it. Save the file and restart your postgres server.

Re: [GENERAL] Lost password

2008-12-17 Thread Allan Kamau
> > Marty. > > --- On Tue, 16/12/08, Allan Kamau wrote: > > From: Allan Kamau > Subject: Re: [GENERAL] Lost password > To: martin_roach2...@yahoo.com.au > Cc: pgsql-general@postgresql.org > Received: Tuesday, 16 December, 2008, 7:32 PM > > > -Inline Attachme

Re: [GENERAL] Lost password

2008-12-16 Thread TJ O'Donnell
It seems you haven't done anything you need to save, so why not save time and just reinstall postgres? TJ Hi  I started the installation of postrgres got distracted and then started again but forgot my password -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make c

Re: [GENERAL] Lost password

2008-12-16 Thread Allan Kamau
It is assumed you are running Unix (or Linux). The commands you've been provided with are standard Unix system commands that will help you find the files (pg_hba.conf) you are looking for, the output of these commands (locate or find) is the absolute path to your queried file (in your case pg_hba.c

[GENERAL] Lost password

2008-12-15 Thread Martin Roach
Hi   I started the installation of postrgres got distracted and then started again but forgot my password. I have received the info below:   Now what? If you have access to shell account on the machine PostgreSQL is running, and your shell works as the same user as Postgres itself, or root - sol