Search Postgresql Archives

Re: Sequences not created, bug in pg_dump?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 03/20/2015 10:21 AM, "Leonardo M. Ramé" wrote:


El 19/03/15 a las 14:13, Adrian Klaver escibió:
On 03/19/2015 10:02 AM, "Leonardo M. Ramé" wrote:

El 19/03/15 a las 13:09, Adrian Klaver escibió:
On 03/19/2015 08:43 AM, "Leonardo M. Ramé" wrote:

Hi, I'm creating a database dump excluding one table and found only
the
sequences created implicitly (using serial type) are created when I
restore the dump.

The command I use is: pg_dump -T table_to_be_excluded mydb

I understand all related objects to the table to be excluded are not
dumpled, but why I don't get any CREATE SEQUENCE command in my dump?.


What version of Postgres?

If I follow you have CREATEd sequence(s) using CREATE SEQUENCE and they
do not show up in the dump file?

It works for me here on 9.3.


Yes that's the problem. The dump is performed using 9.3.5 on windows.

I can not replicate:

aklaver@test=> create sequence test_seq;

aklaver@test=> \d
                    List of relations
  Schema |          Name           |   Type   |  Owner
--------+-------------------------+----------+----------
  public | CamelCap_Quoted         | table    | aklaver
  public | app_sessions            | table    | aklaver
  public | app_users               | table    | aklaver
  public | app_users_vw            | view     | aklaver
  public | app_val_session_vw      | view     | aklaver
  public | camelcap_not_quoted     | table    | aklaver
  public | float_test              | table    | postgres
  public | ins_test                | table    | aklaver
  public | mytable_is_not_readonly | table    | aklaver
  public | mytable_is_readonly     | table    | aklaver
  public | on_duty                 | table    | aklaver
  public | on_duty_id_seq          | sequence | aklaver
  public | seq_counter             | table    | aklaver
  public | t                       | table    | postgres
  public | t_id_seq                | sequence | postgres
  public | tasks                   | table    | aklaver
  public | tasks2                  | table    | aklaver
  public | tasks_task_id_seq       | sequence | aklaver
  public | tbl_test                | table    | aklaver
  public | test_seq                | sequence | aklaver


/usr/local/pgsql93/bin/pg_dump -T app_sessions -U postgres -p 5452 test
 > test_txt.sql


In test_txt.sql:

--
-- Name: test_seq; Type: SEQUENCE; Schema: public; Owner: aklaver
--

CREATE SEQUENCE test_seq
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
     NO MAXVALUE
     CACHE 1;

Do you see any warnings/errors when you run the dump?


Sorry for answering too late, but the problem was solved by using
pg_dump command line instead of doing the backup from pgAdmin. So I
should change the subject of this thread, s/in pg_dump/in pg_admin/g :)

Might want to bring this up here:

http://www.postgresql.org/list/pgadmin-support/


Regards,
Leonardo.




--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux