On 日, 2010-06-13 at 18:26 +0000, Jean Pierre Guillou wrote: > Hi > > I am running Postgresql 8.4 and SL 2.8.30 - no problems with upgrade > or since
I'm so glad I tried this on the backup server first. I just upgraded from 8.1.11 to 8.1.19, but the packages have been reorganized. Gentoo now provides separate postgresql-base and postgresql-server packages. It required uninstalling the old packages and installing the new ones as if it had never been installed before. I don't know how the packages are different from before, but at least directory structures are different. Data now goes in /var/lib/postgresql/8.1/data, whereas it used to be in /var/lib/postgresql/data. I've pointed the program to use the old directory like this, PGDATA="/var/lib/postgresql/data" but I'm afraid some stuff that got created during initialization is not being seen. When I start up sql-ledger I get the login screen, put in my user name and password, and then get this: Error! could not connect to server: Permission denied Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? That socket is there: srwxrwxrwx 1 postgres postgres 0 Jun 18 18:16 /var/run/postgresql/.s.PGSQL.5432 Postgres seems to be running: postgres 3272 0.0 0.0 50508 3068 ? Ss 18:16 0:00 /usr/lib64/postgresql-8.1/bin/postmaster --silent-mode=true postgres 3274 0.0 0.0 50508 1240 ? S 18:16 0:00 postgres: writer process postgres 3275 0.0 0.0 40688 988 ? S 18:16 0:00 postgres: stats buffer process postgres 3276 0.0 0.0 39872 1184 ? S 18:16 0:00 postgres: stats collector process After the install, these messages appeared: Please note that the standard location of the socket has changed from /tmp to /var/run/postgresql and you have to be in the 'postgres' group to access the socket. This can break applications which have the standard location hard-coded. If such an application links against the libpq, please re-emerge it, if that doesn't help or the application accesses the socket without using libpq, please file a bug-report. You can set PGOPTS='-k /tmp' in /etc/conf.d/postgresql-8.1 to restore the original location. I really do not understand this. Can anyone help? (I feel very anxious to be without the backup server.) Thanks, and sorry for the very long post. -- Stuart Luppescu -*-*- slu <at> ccsr <dot> uchicago <dot> edu CCSR in UEI at U of C _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
