[Solved]Is Postgres working properly in siduction?

[vonh]

Is there some way to check if postgresql is working well with Sid?

There are 3 main symptons:

1. I can't locate the postgres executable so I can run different servers.

2. psql generates this error:

Code Select Expand

/usr/lib/postgresql/9.4/bin/psql: symbol lookup error: /usr/lib/postgresql/9.4/bin/psql: undefined symbol: PQconninfo


3. This is the content of the postgresql.log

Code Select Expand

2015-11-05 16:43:41 GMT [31103-1] LOG:  database system was shut down at 2015-11-05 16:43:37 GMT
2015-11-05 16:43:41 GMT [31103-2] LOG:  MultiXact member wraparound protections are now enabled
2015-11-05 16:43:41 GMT [31112-1] LOG:  autovacuum launcher started
2015-11-05 16:43:41 GMT [31098-1] LOG:  database system is ready to accept connections
2015-11-05 16:43:41 GMT [31118-1] [unknown]@[unknown] LOG:  incomplete startup packet
2015-11-05 16:43:47 GMT [31112-2] LOG:  autovacuum launcher shutting down
2015-11-05 16:43:47 GMT [31098-2] LOG:  received smart shutdown request
2015-11-05 16:43:47 GMT [31109-1] LOG:  shutting down
2015-11-05 16:43:47 GMT [31109-2] LOG:  database system is shut down
2015-11-05 16:50:54 GMT [2547-1] LOG:  database system was shut down at 2015-11-05 16:43:47 GMT
2015-11-05 16:50:54 GMT [2547-2] LOG:  MultiXact member wraparound protections are now enabled
2015-11-05 16:50:54 GMT [2551-1] LOG:  autovacuum launcher started
2015-11-05 16:50:54 GMT [2546-1] LOG:  database system is ready to accept connections
2015-11-05 16:50:55 GMT [2557-1] [unknown]@[unknown] LOG:  incomplete startup packet
2015-11-05 16:51:00 GMT [2546-2] LOG:  received smart shutdown request
2015-11-05 16:51:00 GMT [2551-2] LOG:  autovacuum launcher shutting down
2015-11-05 16:51:00 GMT [2548-1] LOG:  shutting down
2015-11-05 16:51:01 GMT [2548-2] LOG:  database system is shut down
2015-11-05 16:52:38 GMT [3592-1] LOG:  database system was shut down at 2015-11-05 16:51:00 GMT
2015-11-05 16:52:38 GMT [3592-2] LOG:  MultiXact member wraparound protections are now enabled
2015-11-05 16:52:38 GMT [3587-1] LOG:  database system is ready to accept connections
2015-11-05 16:52:38 GMT [3596-1] LOG:  autovacuum launcher started
2015-11-05 16:52:38 GMT [3598-1] [unknown]@[unknown] LOG:  incomplete startup packet
2015-11-05 16:52:44 GMT [3587-2] LOG:  received smart shutdown request
2015-11-05 16:52:44 GMT [3596-2] LOG:  autovacuum launcher shutting down
2015-11-05 16:52:44 GMT [3593-1] LOG:  shutting down
2015-11-05 16:52:44 GMT [3593-2] LOG:  database system is shut down


[musca]

Hello vonh,

postgresql is not a typical desktop application. We do neither deliver nor support it officially
and I will move this topic to another category eventually.

For configuration options please refer to https://wiki.debian.org/PostgreSql

I successfully installed the postgresql metapackage, which always depends on the currently supported PostgreSQL database server version and its client. The currently supported version is postgresql-9.4.

root@sidbox:~# dpkg -L postgresql-9.4 | grep bin
[...]
/usr/lib/postgresql/9.4/bin/postgres

root@sidbox:~# systemctl status postgresql
● postgresql.service - PostgreSQL RDBMS
   Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
   Active: active (exited) since Fri 2015-11-06 13:22:12 CET; 7min ago
 Main PID: 407 (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/postgresql.service

Nov 06 13:22:12 sidbox systemd[1]: Starting PostgreSQL RDBMS...
Nov 06 13:22:12 sidbox systemd[1]: Started PostgreSQL RDBMS.
Nov 06 13:22:20 sidbox systemd[1]: Started PostgreSQL RDBMS.

greetings
musca

[vonh]

It turns out I had to use

Code Select Expand

apt-get install postgresql-client-9.4 rather than

Code Select Expand

apt-get install postgresql-client as for some reason that command was installing postgresql-client:i386.