Thread: I have problem with pg_dump in PostgreSQL 7.1.2

<div class="Section1"><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><font color="black"
face="Arial"size="2"><span lang="EN-US" style="font-size:10.0pt; 
font-family:Arial;color:black;mso-ansi-language:EN-US">Hello.</span></font><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;
font-family:Arial;color:black;mso-ansi-language:EN-US">I am working with PostgreSQL 7.1.2. </span></font><p
class="MsoNormal"style="mso-layout-grid-align:none;text-autospace:none"><font color="black" face="Arial" size="2"><span
lang="EN-US"style="font-size:10.0pt; 
font-family:Arial;color:black;mso-ansi-language:EN-US">Earlier I worked with PostgreSQL 6.5.3 and I had no
problems.</span></font><fontcolor="black" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:black"></span></font><pclass="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;
font-family:Arial;color:black;mso-ansi-language:EN-US">How to make, that at pg_dump were taken into account sequence.
Ina file dump.txt it is always created sequnece with initial value 1. </span></font><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;
font-family:Arial;color:black;mso-ansi-language:EN-US">Example:</span></font><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;
font-family:Arial;color:black;mso-ansi-language:EN-US">I have table:</span></font><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;
font-family:Arial;color:black;mso-ansi-language:EN-US">Users (id serial primary key, ….).</span></font><p
class="MsoNormal"style="mso-layout-grid-align:none;text-autospace:none"><font color="black" face="Arial" size="2"><span
lang="EN-US"style="font-size:10.0pt; 
font-family:Arial;color:black;mso-ansi-language:EN-US">And sequence users_id_seq.</span></font><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;
font-family:Arial;color:black;mso-ansi-language:EN-US">I make: /usr/local/pg-7/bin/pg_dump -u -f
/usr/home/andrey/pg/dump.txtdb_name</span></font><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;
font-family:Arial;color:black;mso-ansi-language:EN-US">In file dump.txt creat string:</span></font><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;
font-family:Arial;color:black;mso-ansi-language:EN-US">CREATE SEQUENCE "users_id_seq" start 1 increment 1 maxvalue
2147483647minvalue 1<span style="mso-spacerun:yes">  </span>cache 1 ;</span></font><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;
font-family:Arial;color:black;mso-ansi-language:EN-US">Though should be CREATE SEQUENCE "users_id_seq" start 787
increment1 maxvalue 2147483647 minvalue 1<span style="mso-spacerun:yes">  </span>cache 1 ;</span></font><p
class="MsoNormal"style="mso-layout-grid-align:none;text-autospace:none"><font color="black" face="Arial" size="2"><span
lang="EN-US"style="font-size:10.0pt; 
font-family:Arial;color:black;mso-ansi-language:EN-US">As users_id_seq.</span></font><span lang="EN-US"
style="mso-ansi-language:EN-US"></span><font color="black" face="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;font-family:Arial;
color:black;mso-ansi-language:EN-US">last_value = 787.</span></font><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;
font-family:Arial;color:black;mso-ansi-language:EN-US"> </span></font><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;
font-family:Arial;color:black;mso-ansi-language:EN-US">The version 6.5.3 worked correctly.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-US"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-US"style="font-size: 
10.0pt;font-family:Arial;mso-ansi-language:EN-US">Best regards, Popov Andrey.</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font></div>

Попов Андрей <andrey@cursor.ru> writes:
> I am working with PostgreSQL 7.1.2.
> Earlier I worked with PostgreSQL 6.5.3 and I had no problems.
> How to make, that at pg_dump were taken into account sequence. In a file
> dump.txt it is always created sequnece with initial value 1.

There will be a setval() call in there too, someplace.
        regards, tom lane