I'm stuck. I've been banging my head against a wall for a few days now and I just can't make it work at all any more.
I'm trying to run my PT3 database from my Debian server on my LAN.
I've been all the way through my original linux pgsql thread ( http://www.pokertracker.com/forums/viewtopic.php?f=17&t=7444&st=0&sk=t&sd=a ) 4 times, trying to recreate the way I got it working in the first place, but I just can't get it working.
After upgrading to PT3 B16, I was getting an error during Housekeeping that indicated that my Postgres version might not be the right one, so I checked it using dpkg -l, and lo and behold it said I was only running v.7.4.7, so immediately I set to trying to upgrade at least to version 8 so that PT3 would work.
I checked around and found that there was a testing version of 8.1 and an unstable release of 8.3 available, so I altered my sources.list to allow me to use the other servers and tried 8.3 first, but it failed. I altered my sources.list again and tried 8.1 but this failed as well. I decided to try installing the required packages individually and this gave me loads of errors, so I tried to downgrade back to the stable release, 7.4.7. but still I couldn't get PT3 to connect.
I got an email from Martin Pitt this morning (he apologised for the delay - my email had somehow been overlooked) regarding 8.3 and gave me the details for how to install it from the backport repository. Using his method, 8.3 seemed to install perfectly.
And so in total, I've upgraded, downgraded, installed, removed, installed, upgraded, updated, installed, removed, removed, and installed PostgreSQL.
I came to the conclusion that it's possible that the database just isn't initialised, so I've been trying to work out how to check it.
I found this command on a site somewhere.... and this is what it returns...
postgres@gate:/etc/init.d$ ps -ef | grep postgres
- Code: Select all
root 25686 11666 0 13:34 ? 00:00:00 sshd: postgres [priv]
root 25689 25686 0 13:34 ? 00:00:00 sshd: postgres [priv]
postgres 25691 25686 0 13:34 ? 00:00:00 sshd: postgres@pts/2
postgres 25692 25691 0 13:34 pts/2 00:00:00 -bash
postgres 26235 1 0 14:01 ? 00:00:00 /usr/lib/postgresql/8.3/bin/postgres -D /var/lib/postgresql/8.3/main -c config_file=/etc/postgresql/8.3/main/postgresql.conf
postgres 26237 26235 0 14:01 ? 00:00:00 postgres: writer process
postgres 26238 26235 0 14:01 ? 00:00:00 postgres: wal writer process
postgres 26239 26235 0 14:01 ? 00:00:00 postgres: autovacuum launcher process
postgres 26240 26235 0 14:01 ? 00:00:00 postgres: stats collector process
postgres 26590 25692 0 14:38 pts/2 00:00:00 ps -ef
postgres 26591 25692 0 14:38 pts/2 00:00:00 grep postgres
...but I have no idea what any of it means :D
Right... now the thing is... when I type "dpkg -l" it says I've got BOTH 8.1 AND 8.3 installed. This is entirely possible due to the number of times I installed, uninstalled etc. as detailed above.
When I type "apt-get remove postgresql-8.1" it says "package postgresql-8.1 is not installed, so not removed".
When I type "createdb /usr/var/pgsql1" it says "createdb: could not connect to database postgres: 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'?"
I've checked my pg_hba.conf against the working one from the other thread and I'm pretty sure that it is identical.
I just don't know what to do next. I've pushed and pushed and pushed myself to learn what's going on rather than just ask for help, but I just can't figure it out.
Please, can anyone help me?
I've tied myself in such a knot, and all I want is to be able to play poker with PT3 again.
I don't even care if I have to start a completely new database, just filled up with my HHs! That'd be fine, as long as PT3 is working again. (Though if anyone knows whether my old DB would still be kicking around my linux machine and knows how to find it and restore it, that would be fantastic!)
A thousand pleases... I am at your mercy!
Thanks in advance,
Phil, now with a flat forehead from banging it against the desk too many times.
