Thread: Schema Archive cant find table
I am trying to archive a schema, however there is a certain table that gets skipped with pd_dump The table's name is 'servers'. I checked to see if it is a reserved word, and it does not appear to be... Thinking I was missing something I tried using -t servers, and I get : pg_dump: No matching tables were found Any help? Second question
On 18/02/2011 15:40, trex005 wrote: > I am trying to archive a schema, however there is a certain table that > gets skipped with pd_dump > > The table's name is 'servers'. I checked to see if it is a reserved > word, and it does not appear to be... > > Thinking I was missing something I tried using -t servers, and I get : > pg_dump: No matching tables were found Do you mean schema as in the table definitions etc, or schema as in a particular logical division in the DB? If the latter, you probably have to specify the schema name: pg_dump -t my_schema.servers .... Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
On 02/19/2011 08:03 AM, Raymond O'Donnell wrote: > On 18/02/2011 15:40, trex005 wrote: >> I am trying to archive a schema, however there is a certain table that >> gets skipped with pd_dump >> >> The table's name is 'servers'. I checked to see if it is a reserved >> word, and it does not appear to be... >> >> Thinking I was missing something I tried using -t servers, and I get : >> pg_dump: No matching tables were found > > Do you mean schema as in the table definitions etc, or schema as in a particular logical division in the DB? > > If the latter, you probably have to specify the schema name: > > pg_dump -t my_schema.servers .... > > Ray. > ...and the backup user probably needs rights. Can you select from it? -Andy
On Friday, February 18, 2011 7:40:59 am trex005 wrote: > I am trying to archive a schema, however there is a certain table that > gets skipped with pd_dump What does the log file show when you do the dump? Any output to the screen when the dump is being run? If not maybe run with -v switch to get verbose output? > > The table's name is 'servers'. I checked to see if it is a reserved > word, and it does not appear to be... > > Thinking I was missing something I tried using -t servers, and I get : > pg_dump: No matching tables were found > > Any help? > > Second question -- Adrian Klaver adrian.klaver@gmail.com
On Feb 18, 2011, at 9:10 PM, trex005 wrote: > I am trying to archive a schema, however there is a certain table that > gets skipped with pd_dump > > The table's name is 'servers'. I checked to see if it is a reserved > word, and it does not appear to be... > > Thinking I was missing something I tried using -t servers, and I get : > pg_dump: No matching tables were found > It should not. Try schemaname.tablename with switch -t. Thanks & Regards, Vibhor Kumar