Hello all, I have started to learn postgresql. I am now able to create a database, connect to it, create tables, populate them, etc.
I would like to know how does an ordinary user take a backup of his database? I found that on my debian machine, the data is stored in /var/lib/postgres/data/base/16558. Of course, all of them are binary files and I did a strings * | grep to find out which directory contained my keywords. But the permissions on /var/lib/postgres are as follows: drwx------ 3 postgres postgres 4.0K 2002-09-13 19:39 postgres/ This prevents me from entering the directory to copy it, etc. Should I add myself to the group postgres? What is the preferred way of doing things here? I could not find this piece of information in the man pages. Any pointers would be helpful. Regards, -- Sridhar M.A. Them as has, gets. ------------------------------------------------------- This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. The most comprehensive and flexible code editor you can use. Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial. www.slickedit.com/sourceforge _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
