problems with debian testing install or documentation

Started by john.tigerover 12 years ago2 messagesgeneral
Jump to latest
#1john.tiger
john.tigernassau@gmail.com

tried to follow instructions from postgresql.org/download/linux/debian

1) choice for debian versions wheezy and sid - not for testing (jessie)

2) no mention if any portions of old version should be removed

3) since I'm working on a dev machine, went ahead and removed everything
- there are no instructions on what to remove but went ahead and removed:
postgresql-9.2 postgres-common-9.2 postgresql-client-9.2
postgresql-contrib-9.2postgresql-server-dev-9.2
postgresql postgresql-common postgres-client postgresql-contrib
postgres-server-dev
sudo rm -rf /var/lib/postgresql
sudo rm -rf /var/log/postgresql
sudo rm -rf /etc/postgresql

2) went ahead and installed:
sudo apt-get install postgresql-9.3
sudo apt-get install postgresql-common-9.3
sudo apt-get install postgresql-client-9.3
sudo apt-get install postgresql-contrib-9.3
sudo apt-get install postgresql-server-dev-9.3

3) did get message stating that cluster was removed and need new one

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 ?

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: john.tiger (#1)
Re: problems with debian testing install or documentation

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general