Re: problems with debian testing install or documentation

From: David Johnston <polobo(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: problems with debian testing install or documentation
Date: 2014-01-03 05:58:51
Message-ID: 1388728731826-5785186.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

john.tiger wrote
> 4) su - postgres
> > password --> submitted old one, worked
> $ psql
>
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?
>
> tried to start server: sudo /etc/init.d/postgresql
>
> sudo] password for postgres: xxxxxx
> postgres is not in the sudoers file. This incident will be reported.
>
> 5) checked wiki.debian.org/postgresql - no help
>
> any ideas ?

Don't run sudo when you have su'd to postgres. The Postgres user created
during install is not given sudo privileges. You have to use your
main/admin user.

See this

http://wiki.postgresql.org/wiki/Apt

For the most recent instructions for Debian/Ubuntu via PPA

Quick notes:

These packages allow the various PostgreSQL versions to play well together.

They provide cluster management tools. Two of the most useful are:

pg_lsclusters
pg_ctlcluster

Files go into {base}/{version}/{name} directories which is why they play
well together. A cluster is the combination of version-name

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/problems-with-debian-testing-install-or-documentation-tp5785180p5785186.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message xbzhang 2014-01-03 08:47:28 Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ?
Previous Message john.tiger 2014-01-03 01:50:28 problems with debian testing install or documentation