Re: [ADMIN] dumping tables in non-public schemas..

2002-12-20 Thread Masaru Sugawara
On Fri, 20 Dec 2002 12:00:47 +0530 "Rajesh Kumar Mallah." <[EMAIL PROTECTED]> wrote: > How do we dump a particular schema qualified table using pg_dump? > pg_dump -t shema.tablename database_name > > does not seems to work > In the present, there seems to be no way to do. Pg_dump will come

Re: [ADMIN] dumping tables in non-public schemas..

2002-12-20 Thread Bruce Momjian
Masaru Sugawara wrote: > On Fri, 20 Dec 2002 12:00:47 +0530 > "Rajesh Kumar Mallah." <[EMAIL PROTECTED]> wrote: > > > How do we dump a particular schema qualified table using pg_dump? > > pg_dump -t shema.tablename database_name > > > > does not seems to work > > > > > In the present, there

[ADMIN] ident authentication not working over loopback adapter

2002-12-20 Thread Ian Pilcher
This is a bit backwards. ident authentication is working for me over Unix domain sockets, but it isn't working over the loopback adapter. Here is my /var/lib/pgsql/data/pg_hba.conf: # Allow local and loopback users to connect to self-named databases # local sameuser iden

Re: [ADMIN] ident authentication not working over loopback adapter

2002-12-20 Thread Tom Lane
Ian Pilcher <[EMAIL PROTECTED]> writes: > This is a bit backwards. ident authentication is working for me over > Unix domain sockets, but it isn't working over the loopback adapter. > Notes: This is Red Hat Linux 8.0. Password authentication works over > Unix domain sockets or the loopb

Re: [ADMIN] ident authentication not working over loopback adapter

2002-12-20 Thread Ian Pilcher
Tom Lane wrote: Check to see if ident traffic is being filtered by kernel-level packet filtering. IIRC, RHL ships with mighty tight packet filtering, even on the loopback connection (which is a tad silly, but...). One easy way to investigate this is to see if you can telnet to the ident daemon:

Re: [ADMIN] dumping tables in non-public schemas..

2002-12-20 Thread Masaru Sugawara
On Fri, 20 Dec 2002 12:41:52 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote: > > I also expect that pg_dump/pg_dumpall will have syntax like: > > > >pg_dump -t schema.* database_name > > Yes, it is on the TODO list. > That's great news ! Regards, Masaru Sugawara