pg_resetxlog: command not found

--========GMXBoundary53861269202426396728
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

I do not succeed with pg_resetxlog

root [at] myservercrashedonCOPY :/usr/lib/postgresql/8.4/bin# pg_resetxlog -f /var/lib/postgresql/8.4/main
-bash: pg_resetxlog: command not found

The O.S on the server is Ubuntu Hardy.

I am not sure if I get it right..

Is there an How-to for this available somewhere, or someone has experienced this issue, please ?

Thank you

--========GMXBoundary53861269202426396728
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<html xmlns=3D"http://www.w3.org/1999/xhtml" xml:lang=3D"en" lang=3D"en"><h=
ead><title></title><meta http-equiv=3D"Content-type" content=3D"text/html; =
charset=3DUTF-8" /><style type=3D"text/css">p { margin:0px; padding:0px; }<=
/style></head><body style=3D'background-color:rgb(255, 255, 255);background=
-image:none;background-repeat:repeat;background-position:0% 0%;font-family:=
Verdana,Geneva,Arial,Helvetica,sans-serif;font-size:12px;mar gin-top:0px;mar=
gin-bottom:0px;margin-left:0px;margin-right:0px;padding-top: 5px;padding-bot=
tom:5px;padding-left:5px;padding-right:5px;'><p id=3D"__paragraph__12692021=
29000" style=3D"font-family:Verdana;"><font size=3D"1"><span>I do not succe=
ed with pg_resetxlog</span></font><span></span></p><p id=3D"__paragraph__12=
69202158000" style=3D"font-family:Verdana;">
<font size=3D"1"><span></=
span></font></p><p id=3D"__paragraph__1269202158000" style=3D"font-family:V=
erdana;"><font size=3D"1"><span>root [at] myservercrashedonCOPY :/usr/lib/postgr=
esql/8.4/bin# pg_resetxlog -f /var/lib/postgresql/8.4/main
-bash: pg_r=
esetxlog: command not found
</span></font></p><p id=3D"__paragraph__12=
69202158000" style=3D"font-family:Verdana;">
<font size=3D"1"><span></=
span></font></p><p id=3D"__paragraph__1269202158000" style=3D"font-family:V=
erdana;"><font size=3D"1"><span>The O.S on the server is Ubuntu Hardy. </sp=
an></font><span></span></p><p id=3D"__paragraph__1269202227000" style=3D"fo=
nt-family:Verdana;">
</p><p id=3D"__paragraph__1269202227000" style=3D=
"font-family:Verdana;">I am not sure if I get it right..
</p><p id=3D=
"__paragraph__1269202227000" style=3D"font-family:Verdana;">
</p><p id=
=3D"__paragraph__1269202227000" style=3D"font-family:Verdana;">Is there an =
How-to for this available somewhere, or someone has experienced this issue,=
please ?<span></span></p><p id=3D"__paragraph__1269202414000" style=3D"fon=
t-family:Verdana;">
</p><p id=3D"__paragraph__1269202414000" style=3D"=
font-family:Verdana;">Thank you
</p><p id=3D"__paragraph__126920224700=
0" style=3D"font-family:Verdana;">
</p><p id=3D"__paragraph__126920224=
7000" style=3D"font-family:Verdana;">
</p></body></html>

--========GMXBoundary53861269202426396728--
Yazid Levasseur [ So, 21 März 2010 21:11 ] [ ID #2035879 ]

Re: pg_resetxlog: command not found

--=-FH7cFnE/TSmmPyJe36JC
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sun, 2010-03-21 at 21:11 +0100, Yazid Levasseur wrote:
> root [at] myservercrashedonCOPY :/usr/lib/postgresql/8.4/bin# pg_resetxlog
> -f /var/lib/postgresql/8.4/main
> -bash: pg_resetxlog: command not found

Either ./pg_resetxlog -f ... ,
or /usr/lib/postgresql/8.4/bin/pg_resetxlog -f .... Another way is
adding /usr/lib/postgresql/8.4/bin to $PATH.
--
Devrim G=C3=9CND=C3=9CZ
PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

--=-FH7cFnE/TSmmPyJe36JC
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEABECAAYFAkunYhEACgkQtl86P3SPfQ5HLwCgnsTyqXbYkGOd+3M43s8T MVU4
+HEAoKQbKvUubHrT45Iisvs/iO8YBrij
=iJBi
-----END PGP SIGNATURE-----

--=-FH7cFnE/TSmmPyJe36JC--
devrim [ Mo, 22 März 2010 13:26 ] [ ID #2035933 ]
Datenbanken » gmane.comp.db.postgresql.admin » pg_resetxlog: command not found

Vorheriges Thema: Store database users in custom table
Nächstes Thema: upgrade 8.3.7 to 8.3.10 combined with ownership change