postgresql

How to enable logging in Postgresql 9.2 and 9.1

by

In this post we will learn how to enable logging in Postgresql 9.2 and 9.1.It is a quick method to enable logging in Postgresql 9.2 and 9.1.We will do changes in postgresql.conf file. Path in Postgresql 9.1 : /etc/postgresql/9.1/main/postgresql.conf Path in Postgresql 9.2 : /etc/postgresql/9.2/main/postgresql.conf To enable the log for all queries in Postgresql,follow the … Read more

postgres database backup script using database user password inside

by

Postgresql is open source object-relational database system and it is also widely use likewise mysql database system. If you are familiar with mysql you must be aware that in single line you can pass the password of mysql user for eg. mysql -u root -p password. But in postgresql it is not like that. Solution: … Read more