2009-02-11 20:01:03 |
Michael Lustfield |
description |
Binary package hint: postgresql-8.3
Running a standard 'apt-get install postgresql' on a freshly installed Ubuntu 8.04 server should result in a working PostgreSQL installation in /var/lib/postgresql/8.3 with configuration files accessible from /etc/postgresql/8.3, as described in [1]. It does not.
$ /etc/init.d/postgresql start
does nothing, nor is there any evidence of a running PostgreSQL server in 'top' or 'ps aux'.
It seems the packages containing the PostgreSQL server are very incomplete. By running the above command the following packages are fetched and installed:
postgresql_8.3.1-1_all.deb
postgresql-8.3_8.3.1-1_i386.deb
postgresql-client_8.3.1-1_all.deb
postgresql-client-8.3_8.3.1-1_i386.deb
postgresql-client-common_87_all.deb
postgresql-common_87_all.deb
postgresql-contrib_8.3.1-1_all.deb
postgresql-contrib-8.3_8.3.1-1_i386.deb
postgresql-doc_8.3.1-1_all.deb
postgresql-doc-8.3_8.3.1-1_all.deb
I believe the first two and postgresql-common_87_all.deb should contain the actual server and config file installations, but they don't. Manually extracting the package files confirms that they do not contain anything related to /var/lib/postgresql/8.3 or /etc/postgresql/8.3:
$ ls -1
postgresql_8.3.1-1_all.deb
postgresql-8.3_8.3.1-1_i386.deb
postgresql-common_87_all.deb
$ for i in postgresql*; do dpkg --extract $i . ; done
$ ls -1
etc
postgresql_8.3.1-1_all.deb
postgresql-8.3_8.3.1-1_i386.deb
postgresql-common_87_all.deb
postgresql-contrib_8.3.1-1_all.deb
postgresql-contrib-8.3_8.3.1-1_i386.deb
usr
var
$ ls -1R var
var:
lib
log
var/lib:
postgresql
var/lib/postgresql:
var/log:
postgresql
var/log/postgresql:
$ ls -1R etc
etc:
cron.d
init.d
logrotate.d
postgresql-common
etc/cron.d:
postgresql-common
etc/init.d:
postgresql-8.3
etc/logrotate.d:
postgresql-common
etc/postgresql-common:
autovacuum.conf
pg_upgradecluster.d
etc/postgresql-common/pg_upgradecluster.d:
That's not much to run a DBMS server. Though I believe that these are the relevant packages I also manually extracted all the others, but as I said in the beginning, no server is installed and no configuration files apart from the ones in /usr/share/postgresql/8.3, which are all .samples.
I would gladly provide more information, please tell me if I can do anything.
[1] https://help.ubuntu.com/8.04/serverguide/C/postgresql.html |
Binary package hint: postgresql-8.3
Running a standard 'apt-get install postgresql' on a freshly installed Ubuntu 8.04 server should result in a working PostgreSQL installation in /var/lib/postgresql/8.3 with configuration files accessible from /etc/postgresql/8.3, as described in [1]. It does not.
[1] https://help.ubuntu.com/8.04/serverguide/C/postgresql.html |
|
2009-02-12 18:32:21 |
Michael Lustfield |
postgresql-8.3: statusexplanation |
The cluster is not shipped in the package, but created by the package at installation time. The most common cause why this isn't working is that your locale settings are broken. Please do
sudo dpkg -P postgresql-8.3 postgresql-client-8.3
sudo apt-get install postgresql-8.3
and copy&paste the output of the latter command. Thanks! |
I'm glad that helped. I'm sorry I couldn't help you quicker too. |
|