On Mon, 08 May 2006 15:47:13 -0600 Blair Lowe <postgresql@xxxxxxxxxxx> wrote: > Hi, > > I have had this problem for a while, and have not been able to find > anything in the archives or on search engines: > > If I want to back up a client's database on our shared web server, I > would type: > > pg_dump <database_name> > > Since we are running a shared server, and since crappy (only because > of this problem) off the shelf database open source software such as > oscommerce, or phpBB2 grants access to public rather than the web user > "www" or "nobody", when I do a pg_dump for a database, I get all the > databases on the system that grant to PUBLIC being dumped with with > database that I want. > > To restore, I need to go in and prune out all the extra junk that was > granted to PUBLIC by other users in other databases - very time > consuming. > > How can I use pg_dump to get JUST the database in th argument, and not > other tables and databases that have granted to PUBLIC? > > Altering my client's software to grant to "nobody" is not practical. > > Thanks in advance, > Blair. > > > ---------------------------(end of > broadcast)--------------------------- TIP 2: Don't 'kill -9' the > postmaster Blair, <UNTESTED> How about setting up a seperate schema (private), adding your customer's database to it (leaving it in public) and then backing up private.customerdb? </UNTESTED> John Purser -- You need more time; and you probably always will.
