On Wed, Mar 6, 2013 at 2:38 PM, ning chan <ninchan8328@xxxxxxxxx> wrote:
This means the server wasn't compiled with WAL_DEBUG defined. You have to do both things, first compile with WAL_DEBUG, and then set the wal_debug guc to on.
I've never bothered to do that and it never gave me any problems (but I wouldn't so on a running production system). You do need to run make maintainer-clean before you redo the ./config and build and install, though.
If you originally installed from source yourself using the normal build tools, uninstalling should need nothing more than removing the directory that --prefix was originally set to. If you had built other things that linked against the installation (DBD::Pg, for example) they will be broken by this, but they should work again once you redo the install.
If you installed some other way, I don't know.
Cheers,
Jeff
this is the error message i got:Hi Jeff,Thanks for your reply.
-bash-4.1$ pg_ctl start
server starting
-bash-4.1$ LOG: unrecognized configuration parameter "wal_debug" in file "/usr/local/pgsql/data/postgresql.conf" line 162
FATAL: configuration file "/usr/local/pgsql/data/postgresql.conf" contains errors
This means the server wasn't compiled with WAL_DEBUG defined. You have to do both things, first compile with WAL_DEBUG, and then set the wal_debug guc to on.
One question: Do i need to uninstall first before I gmake install again?
I've never bothered to do that and it never gave me any problems (but I wouldn't so on a running production system). You do need to run make maintainer-clean before you redo the ./config and build and install, though.
If so, any idean how to uninstall it?
If you originally installed from source yourself using the normal build tools, uninstalling should need nothing more than removing the directory that --prefix was originally set to. If you had built other things that linked against the installation (DBD::Pg, for example) they will be broken by this, but they should work again once you redo the install.
If you installed some other way, I don't know.
Cheers,
Jeff
