Re: Why can't I do this (setup question) - Mailing list pgsql-general

From Karl DeBisschop
Subject Re: Why can't I do this (setup question)
Date
Msg-id 3B07C797.61F135D6@debisschop.net
Whole thread Raw
In response to Why can't I do this (setup question)  (Paul Tomblin <ptomblin@xcski.com>)
List pgsql-general
Paul Tomblin wrote:
>
> Quoting Tom Lane (tgl@sss.pgh.pa.us):
> > Paul Tomblin <ptomblin@xcski.com> writes:
> > > I've got PostgreSQL 7.1 installed from rpms on a RedHat 6.2 system.  I
> > > want the data directory on a separate partition, so I shut down, tar the
> > > whole directory into the other directory, mount it, and when I start up
> > > postgresSQL it says it's up, but I can't connect to any databases using
> > > psql.
> > > psql: connectDBStart() -- connect() failed: Connection refused
> > >         Is the postmaster running locally
> > >         and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
> > > There is a postmaster running, but no socket in /tmp/
> >
> > Odd.  Seems unlikely that that has anything to do with your having moved
> > the data directory.  Any interesting messages in the postmaster log?
> > Can you connect via TCP?
>
> Is there a postmaster log other than what's in /var/log/messages?
> Because there is nothing useful in there other than a message that it
> started successfully.

As for your original question, which I missed, I assume you set '-i' in
postmaster.opts.default.

As for the log issue, you can also set log level in
postmaster.opts.default

--
Karl

pgsql-general by date:

Previous
From: Paul Tomblin
Date:
Subject: Re: Why can't I do this (setup question)
Next
From: Tom Lane
Date:
Subject: Re: Why can't I do this (setup question)