But an upgrade / uninstall of the old version should take care of those files. Running a copy from source maybe?
please help postgres IDENT error
well the init.d srcipt launches one postgres only, and i see no other running, and there seems to be only one binary in
/usr/lib/postgresql/bin/pg_dump
and there are links of them in the /usr/bin (actually they link to /usr/bin/pg_wrapper)
Yeah, just wondering really. Do you find duplicates of other common pg files like postgresql.conf pr the pg_xlog directory with locate?
(i.e. locate pg_xlog)
hm it seems postresql.conf can be found only in /etc/postgres no pg_xlog present
locate postgresql.conf
/etc/postgresql/postgresql.conf
/etc/postgresql/postgresql.conf.dpkg-dist
/usr/share/doc/postgresql/README.postgresql.conf
/usr/share/postgresql/postgresql.conf.in
/usr/share/postgresql/postgresql.conf.sample
/var/lib/dpkg/info/postgresql.conffiles
/var/lib/dpkg/info/postgresql.config
/var/lib/ucf/cache/:etc:postgresql:postgresql.conf
you'll need to be root or postgres to find those files that are locked away in a postgres owned dir with locate btw...
did it as root no pg_xlog
That's unpossible! Seriously, unless you're running a really REALLY old version of Postgresql, you have to have a pg_xlog directory, it's part and parcel of the db server, used for write ahead logging. It can't even start up without that directory.
ok you're right there is, but locate does not show it:
www:~# whoami
root
www:~# locate pg_xlog
www:~# find / -name pg_xlog
/var/lib/postgres/data/pg_xlog
Yeah, it's likely in a directory that's excluded from updatedb / locate access.
yes, and it still looks like there is only one pg installed, and postgres.conf is loaded from /etc/postgres !
can it be, that when there is a pg_hba.conf in the data dir, then it overrides the default one in /etc/postgres ?
I'm not real familiar with the way debian / postgresql works, so I can't really say. I would expect that the pg_hba.conf in the data directory would be the one to be used. it might at one time have been linked to the one in /etc...
I do know that the debian team is working on a system that will allow a machine to have multiple postgresql packages installed in different data directories do you can have V 7.4.x and V 8.0.x installed at the same time using packages. i doubt that you are running into that, as it is still in the early stages of development from what I've read.
well, it seems to work fine now...
thanks for your help!