Re: pg_dump not dumping some schemas - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: pg_dump not dumping some schemas
Date
Msg-id A737B7A37273E048B164557ADEF4A58B36618F8D@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: pg_dump not dumping some schemas  ("Guo, Yun" <YGuo@cvent.com>)
List pgsql-admin
Yun Guo wrote:
> Here¹s the output:
> 
> polling_etl=# SELECT oid FROM pg_catalog.pg_namespace n polling_etl-# WHERE n.nspname ~ '^(test)$';
>   oid
> -------
>  17972
> (1 row)
> polling_etl=# SELECT tableoid, oid, nspname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid =
> nspowner) AS rolname, nspacl FROM pg_catalog.pg_namespace;
>  tableoid |   oid   |      nspname       |  rolname  |
>                 nspacl
> ----------+---------+--------------------+-----------+------------------
> ----------+---------+--------------------+-----------+---
> -----------------------------------------------------------
>      2615 |      99 | pg_toast           | postgres  |
>      2615 |   11215 | pg_temp_1          | postgres  |
>      2615 |   11216 | pg_toast_temp_1    | postgres  |
>      2615 |      11 | pg_catalog         | postgres  |
> {postgres=UC/postgres,=U/postgres}
>      2615 |    2200 | public             | postgres  |
> {postgres=UC/postgres,=UC/postgres}
>      2615 |   12348 | information_schema | postgres  |
> {postgres=UC/postgres,=U/postgres}
>      2615 | 1131042 | test2              | pb_writer |
> {pb_writer=UC/pb_writer,test2=U/pb_writer}
>      2615 |   16389 | polling_etl        | pb_writer |
> {pb_writer=UC/pb_writer,polling_etl=UC/pb_writer}
>      2615 |   17944 | mdev1              | pb_writer |
> {pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,mdev1=U/pb_writ
> er}
>      2615 |   17946 | mdev2              | pb_writer |
> {pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,mdev2=U/pb_writ
> er}
>      2615 |   17957 | mdev3              | pb_writer |
> {pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,mdev3=U/pb_writ
> er}
>      2615 |   17970 | mdev4              | pb_writer |
> {pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,mdev4=U/pb_writ
> er}
>      2615 |   17972 | test               | pb_writer |
> {pb_writer=UC/pb_writer,=U/pb_writer,postgres=U*C/pb_writer,test=U/pb_write
> r}
> (13 rows)

That looks fine to me.

I don't understand what is going on there.

> Is there a way to repair the database if it's corrupted?

It oes not look corrupted, but if it were, a restore would help.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump not dumping some schemas
Next
From: Andre_Mikulec
Date:
Subject: Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?