pg_resetxlog command not found
I am doing some experimentation with a WAL archiving HA setup. I tried
turning to the pg_resetxlog command after removing some corrupted
files and it is not installed using the ubuntu dapper 8.1 package. How
do I get this command installed, or is there some other way to repair
a database that is missing the pg_xlog directory files? I find it odd
that the pg_resetxlog command is just missing... I have postgres
installed from source on my laptop and it is there.
Thanks,
Matt
After poking around some more the command is located in
/usr/lib/postgresql/8.1/bin/pg_resetxlog on ubuntu.
Show quoted text
On 6/18/07, Matt Bartolome <mattxbart@gmail.com> wrote:
I am doing some experimentation with a WAL archiving HA setup. I tried
turning to the pg_resetxlog command after removing some corrupted
files and it is not installed using the ubuntu dapper 8.1 package. How
do I get this command installed, or is there some other way to repair
a database that is missing the pg_xlog directory files? I find it odd
that the pg_resetxlog command is just missing... I have postgres
installed from source on my laptop and it is there.Thanks,
Matt
"Matt Bartolome" <mattxbart@gmail.com> writes:
I am doing some experimentation with a WAL archiving HA setup. I tried
turning to the pg_resetxlog command after removing some corrupted
files and it is not installed using the ubuntu dapper 8.1 package.
Maybe they put it in some subpackage you didn't install? A very long
time ago (7.2 days) it was one of our contrib modules, so it's
conceivable that someone might be packaging it in postgresql-contrib
still. I didn't think ubuntu was around that long though. I believe
most packagers these days put it in the -server subpackage.
If they really didn't include it anywhere, get a better Linux distro.
regards, tom lane
Is so easy
use pg_config command
sudo apt-get install libpg-dev
use use pg_config command
viney@viney ~ $ pg_config
BINDIR = /usr/lib/postgresql/9.1/bin
DOCDIR = /usr/share/doc/postgresql
HTMLDIR = /usr/share/doc/postgresql
INCLUDEDIR = /usr/include/postgresql
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/9.1/server
LIBDIR = /usr/lib
PKGLIBDIR = /usr/lib/postgresql/9.1/lib
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/postgresql/9.1/man
SHAREDIR = /usr/share/postgresql/9.1
SYSCONFDIR = /etc/postgresql-common
cd /usr/lib/postgresql/9.1/bin
pg_resetxlog is here.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-resetxlog-command-not-found-tp1883533p5748112.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general