Re: [ADMIN] PostgreSQL question

2011-09-27 Thread Mridul Mathew
Okay, thanks! -Mridul. On Tue, Sep 27, 2011 at 12:14 AM, Guillaume Lelarge wrote: > On Mon, 2011-09-26 at 16:06 +0530, Mridul Mathew wrote: > > Hello, > > > > I wanted to take a moment here and reach out to the community with a > > question. How does postgreSQL handle schema switching in the dat

Re: [ADMIN] PostgreSQL question

2011-09-26 Thread Guillaume Lelarge
On Mon, 2011-09-26 at 16:06 +0530, Mridul Mathew wrote: > Hello, > > I wanted to take a moment here and reach out to the community with a > question. How does postgreSQL handle schema switching in the database? I > have a test scenario. > > ## > > vpn2=> show search_path; > sear

Re: [ADMIN] postgresql question

2011-01-21 Thread Tom Lane
"Kevin Grittner" writes: > Dennis Hoffman wrote: >> What can I do? > I'd be tempted to write a script which was owned by root which > calculated the size as desired, and grant sudo rights to merlin to > execute that particular script as the user with rights. Seems like a postgres-owned script

Re: [ADMIN] postgresql question

2011-01-21 Thread Kevin Grittner
Dennis Hoffman wrote: > If I do nothing other than remove the file permissions ( change > back to 700 from 750 ), the Postmaster starts just as it should. > Why does the Postmaster not start with the group permissions > changed? That's intentional, as a security measure. > Is this a bug?