You are not logged in.
After reboot Postgresql doesn't see my databases.
Facts:
I didn't upgrade, and I'm far behind (Pacman is synced to about 04.2012)
pacman -Qi postgresql | grep Ver
Version : 9.1.3-1
cat /var/lib/postgres/data/PG_VERSION
9.1
postgres=# \list [cutted]:
Name
-------------
postgres
template0
template1
pg_dumpall output is generally empty:
pg_dumpall > backup.sql
cat backup.sql | grep CREATE
CREATE ROLE postgres;
ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION;
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
/var/log/postgresql.log is OK - only info (LOG).
Something is there:
du -sh /var/lib/postgres/data/
185M /var/lib/postgres/data/
PS. I've tried to ask for help on pgsql-admin@postgresql.org, but it looks like almost no one uses it - only couple of mails for 2 weeks. Somebody knows some good place to talk about Postgres?
Offline
What you get from this command
select setting from pg_settings where name = 'data_directory';
You can try #postgresql channel on irc.freenode.net, lots of helpful folks there.
Last edited by mloskot (2013-03-17 21:59:45)
Mateusz Loskot | github | archlinux-config
Arch (x86-64) | ThinkPad T400 | Intel P8600| Intel i915
Arch (x86-64) | ThinkPad W700 | Intel T9600 | NVIDIA Quadro FX 2700M
Offline
What you get from this command
select setting from pg_settings where name = 'data_directory';
postgres=# select setting from pg_settings where name = 'data_directory';
setting
------------------------
/var/lib/postgres/data
(1 row)
Permissions are also OK:
dirs: 700 postgres.postgres
files: 600 postgres.postgres
Thanks for info, I'll try get some help on IRC too.
Offline
The values look correct. I honestly don't know what might have changed after simple reboot. Hopefully folks on IRC will help.
Mateusz Loskot | github | archlinux-config
Arch (x86-64) | ThinkPad T400 | Intel P8600| Intel i915
Arch (x86-64) | ThinkPad W700 | Intel T9600 | NVIDIA Quadro FX 2700M
Offline