Ok, made it listen_addresses = '*' Now, can you please help me start the server. ( As I mentioned in earlier post, 'service postgresql restart' had stopped the server but *server start failed*.)
Step wise list of commands to be given would be great! Do I need to login as postgres? Thanks On Tue, Mar 2, 2010 at 7:27 PM, Kenneth Marshall <[email protected]> wrote: > You cannot have a '*' in listen_addresses with anything else. > That already means bind to EVERY available interface. When you > added localhost, it tried to re-bind localhost twice. Try just > using '*'. > > Cheers, > Ken > > On Tue, Mar 02, 2010 at 07:19:47PM +0530, Major Services wrote: > > pgstartup.log: > > > > The files belonging to this database system will be owned by user > > "postgres". > > .... > > .... > > > > Success. You can now start the database server using: > > /usr/bin/postmaster -D /var/lib/pgsql/data > > or > > /usr/bin/pg_ctl -D /var/lib/pgsql/data -1 logfile start > > FATAL: lock file "postmaster.pid"already exists > > HINT:Is another postmaster (PID 3300) running in data > > directory"b/pgsql/data"? > > LOG: logger shutting down > > runuser: cannot set groups: Operation not permitted > > LOG: logger shutting down > > FATAL: syntax error in file "/var/lib/pgsql/data/postgresql.conf", near > > token "," > > > > > > Now, in the "/var/lib/pgsql/data/postgresql.conf" the only change I have > > made is in listen_addresses; viz > > listen_addresses = 'localhost', '*' > > > > Let me know how to move ahead. > > Thanks. > > > > On Tue, Mar 2, 2010 at 5:55 PM, I?igo Martinez Lasala < > > [email protected]> wrote: > > > > > Ah... ok. > > > In /var/lib/pgsql you will find a file called pgstartup.log > > > Could you post here last lines of this file ? > > > > > > > > > > > > -----Original Message----- > > > *From*: Major Services <[email protected]< > major%20services%20%[email protected]<major%2520services%2520%[email protected]> > %3e> > > > > > > > *To*: I?igo Martinez Lasala <[email protected]<% > 3d%3fiso-8859-1%3fq%3fi%3df1igo%3f%3d%20martinez%20lasala%20%[email protected]<3d%253fiso-8859-1%253fq%253fi%253df1igo%253f%253d%2520martinez%2520lasala%2520%[email protected]> > %3e> > > > > > > > *Cc*: [email protected] > > > *Subject*: Re: [ADMIN] password authentication failed for user postgres > > > *Date*: Tue, 2 Mar 2010 16:40:47 +0530 > > > > > > But the server restart has failed; I am yet to make the changes > suggested > > > by you in the first instance. > > > > > > > > > > > > > > > On Tue, Mar 2, 2010 at 4:32 PM, I?igo Martinez Lasala < > > > [email protected]> wrote: > > > > > > Try with these parameters in pg_hba.conf. Perhaps your postgres-redhat > > > compilation does not have ident enabled... > > > > > > local all postgres trust > > > > > > > > > > > > > > > -----Original Message----- > > > *From*: Major Services <[email protected]< > major%20services%20%[email protected]<major%2520services%2520%[email protected]> > %3e> > > > > > > > > > > > > > *To*: I?igo Martinez Lasala <[email protected]<% > 3d%3fiso-8859-1%3fq%3fi%3df1igo%3f%3d%20martinez%20lasala%20%[email protected]<3d%253fiso-8859-1%253fq%253fi%253df1igo%253f%253d%2520martinez%2520lasala%2520%[email protected]> > %3e> > > > > > > > *Subject*: Re: [ADMIN] password authentication failed for user postgres > > > *Date*: Tue, 2 Mar 2010 16:03:59 +0530 > > > > > > Thank you for your message. But am in another problem now. > > > In between I also tried to restart the server with 'service postgresql > > > restart' > > > It stopped the server, but then *server start failed*. > > > Had restarted earlier also, without a problem. > > > > > > What should I do? > > > > > > On Tue, Mar 2, 2010 at 2:44 PM, I?igo Martinez Lasala < > > > [email protected]> wrote: > > > > In order to lauch createuser you don't need to modify listen_address > > > since > > > > you can use unix sockets. But anyway it's a requirement if you are > goint > > > to > > > > access remotely. > > > > > > > > Add this line in first place to your pg_hba.conf > > > > local all postgres ident sameuser > > > > > > > > > > > > Reload postgresql and launch createuser as postgres user. > > > > > > > > > > > > -----Original Message----- > > > > From: Major Services <[email protected]> > > > > To: [email protected] > > > > Subject: [ADMIN] password authentication failed for user postgres > > > > Date: Tue, 2 Mar 2010 14:13:10 +0530 > > > > > > > > Hi, > > > > > > > > 1. I have added listen_addresses = '*' ; in postgresql.conf > > > > > > > > 2. And have made the following changes to pg_hba.conf > > > > > > > > local DATABASE USER METHOD > > > > local samegroup all password > > > > host DATABASE USER CIDR-ADDRESS METHOD [OPTION] > > > > host all all 0.0.0.0/0 > md5 > > > > hostssl all all 0.0.0.0/0 md5 > > > > > > > > 3. Have restarted the server > > > > > > > > 4. I can login to the server as user postgres. > > > > > > > > But while trying to createuser I get the following message : > > > > 'createuser: could not connect to database postgres: FATAL : > > > > password authentication failed for user "postgres" > > > > > > > > This is on Redhat running Plesk also. > > > > > > > > I am new to Linux as well as PostgreSQL. Help would be much > appreciated. > > > > > > > > Thanks > > > > Viv > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
