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
Since we are running a shared server, and since crappy (only because of
this problem)
On Tue, 2006-09-05 at 00:09 +0200, Martijn van Oosterhout wrote:
> On Mon, May 08, 2006 at 03:47:13PM -0600, Blair Lowe wrote:
> > If I want to back up a client's database on our shared web server, I
> > would type:
> >
> > pg_dump
> >
> > Since we a
On Mon, 2006-08-05 at 15:54 -0700, Joshua D. Drake wrote:
> > Not sure how else to describe this: basically if you type in pg_dump
> > then all databases on the system that have table grants
> > to public are also in the backup .sql file with connect commands to the
> > other database users.
>
>
On Mon, 2006-08-05 at 16:32 -0700, Joshua D. Drake wrote:
> Hello,
>
> What version of PostgreSQL is this that you are using? Because it
]# rpm -qi postgresql
Name: postgresql Relocations: (not
relocateable)
Version : 7.3.4 Vendor: Red H
On Tue, 2006-09-05 at 13:19 +1200, Brent Wood wrote:
>
> On Mon, 8 May 2006, Blair Lowe 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
On Tue, 2006-09-05 at 12:25 -0400, Tom Lane wrote:
> Blair Lowe <[EMAIL PROTECTED]> writes:
> > On Mon, 2006-08-05 at 16:32 -0700, Joshua D. Drake wrote:
> >> What version of PostgreSQL is this that you are using? Because it
>
> > ]# rpm -qi postgr
On Tue, 2006-09-05 at 21:08 +0200, Martijn van Oosterhout wrote:
> On Tue, May 09, 2006 at 10:52:32AM -0600, Blair Lowe wrote:
> > In my test I do not see stuff2 either. The problem here is that I have
> > sensitive production data, so my tests are hard to read, and not able to
On Thu, 2006-11-05 at 18:44 +0200, Martijn van Oosterhout wrote:
> On Thu, May 11, 2006 at 10:41:51AM -0600, Blair Lowe wrote:
> > [EMAIL PROTECTED] etc]# psql temp99
> > Welcome to psql 7.3.4, the PostgreSQL interactive terminal.
> >
> > Type: \copyright for distr
On Thu, 2006-11-05 at 11:09 -0700, Joshua D. Drake wrote:
> > select relname from pg_class where oid = 17736;
> > relname
> > -
> > bbs_auth_access
> > (1 row)
> >
> > phpbb_mainlandpc=> \q
> >
> > To access this user's table, I can be logged on as anyone, and that is
>
On Fri, 2006-12-05 at 10:08 -0700, Adrian Klaver wrote:
> On Friday 12 May 2006 09:50 am, Blair Lowe wrote:
> See following-
> -n schema
> --schema=schema
>
> Dump the contents of schema only. If this option is not specified, all
> non-system schemas in the target da
On Fri, 2006-12-05 at 10:51 -0700, Joshua D. Drake wrote:
> >> user# pg_dump -n > tmp95.sql
> >> pg_dump: invalid option -- n
> >> Try 'pg_dump --help' for more information.
> >>
> >> phpbb only works with version 7.x.
>
>
> Oh... if you are running 7.3 your pretty much hosed... You need to
> u
On Fri, 2006-12-05 at 10:57 -0700, Joshua D. Drake wrote:
> Blair Lowe wrote:
> > On Fri, 2006-12-05 at 10:51 -0700, Joshua D. Drake wrote:
> >>>> user# pg_dump -n > tmp95.sql
> >>>> pg_dump: invalid option -- n
> >>>> Try 'pg_dump --h
12 matches
Mail list logo
