How to enable debug mode in PostgreSQL?

1.	How to enable debug mode in PostgreSQL?
Answer» PgAdmin comes with built-in support to DEBUG your Pl/PgSQL codes. However, in order to enable this, you need to compile and INSTALL a SEPARATE plug-in for PostgreSQL Now, once you have set up a proper environment for debugging, GO to EDIT /etc/postgresql/9.4/main/postgresql.conf and enable the debugger plugin.

Answer»

PgAdmin comes with built-in support to DEBUG your Pl/PgSQL codes. However, in order to enable this, you need to compile and INSTALL a SEPARATE plug-in for PostgreSQL

Now, once you have set up a proper environment for debugging, GO to EDIT /etc/postgresql/9.4/main/postgresql.conf and enable the debugger plugin.

Discussion

No Comment Found

Related InterviewSolutions

What is a CTID of PostgreSQL?
How to take the backup of PostgreSQL?
How to enable debug mode in PostgreSQL?
How to check status of PostgreSQL server running or not?
What are the ODBC drivers that are available for PostgreSQL?
What is the command that can be used to allocate memory in postgreSQL?
How many byte Unique integers does OIDs in PostgreSQL?
What is inverted file in PostgreSQL?
What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?
What is purpose of overlay function in PostgreSQL?

How to enable debug mode in PostgreSQL?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment