Re: migration still a problem

From: "P(dot) Jourdan" <pippo(at)videotron(dot)ca>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: migration still a problem
Date: 2002-04-14 18:49:36
Message-ID: 5.1.0.14.2.20020414144651.00a8fd88@pop.videotron.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

At 11:25 AM 4/14/2002 -0700, you wrote:

>Next step: First, copy the original file in case your text editor
>causes problems. Second, copy the, say, first 30 lines of the file and
>post them with your next reply. That should be enough to tell if it's
>a pg_dump or pg_dumpall file.
>
>-Josh

Here are the first 25 lines:

Username: Password:
\connect - med
CREATE SEQUENCE "category_category_id_seq" start 60 increment 1 maxvalue
2147483647 minvalue 1 cache 1 ;
SELECT nextval ('"category_category_id_seq"');
CREATE SEQUENCE "contact_contact_id_seq" start 576 increment 1 maxvalue
2147483647 minvalue 1 cache 1 ;
SELECT nextval ('"contact_contact_id_seq"');
CREATE SEQUENCE "currency_rates_currency_rate" start 21 increment 1
maxvalue 2147483647 minvalue 1 cache 1 ;
SELECT nextval ('"currency_rates_currency_rate"');
CREATE SEQUENCE "customer_customer_id_seq" start 49 increment 1 maxvalue
2147483647 minvalue 1 cache 1 ;
SELECT nextval ('"customer_customer_id_seq"');
CREATE SEQUENCE "flow_flow_id_seq" start 5 increment 1 maxvalue 2147483647
minvalue 1 cache 1 ;
SELECT nextval ('"flow_flow_id_seq"');
CREATE SEQUENCE "news_news_id_seq" start 1 increment 1 maxvalue 2147483647
minvalue 1 cache 1 ;
SELECT nextval ('"news_news_id_seq"');
CREATE SEQUENCE "order_status_order_status_id" start 7 increment 1 maxvalue
2147483647 minvalue 1 cache 1 ;
SELECT nextval ('"order_status_order_status_id"');
CREATE SEQUENCE "order_types_order_type_id_se" start 3 increment 1 maxvalue
2147483647 minvalue 1 cache 1 ;
SELECT nextval ('"order_types_order_type_id_se"');
CREATE SEQUENCE "orders_order_id_seq" start 4 increment 1 maxvalue
2147483647 minvalue 1 cache 1 ;
SELECT nextval ('"orders_order_id_seq"');
CREATE SEQUENCE "pages_pages_id_seq" start 26 increment 1 maxvalue
2147483647 minvalue 1 cache 1 ;
SELECT nextval ('"pages_pages_id_seq"');
CREATE SEQUENCE "price_types_price_type_id_se" start 5 increment 1 maxvalue
2147483647 minvalue 1 cache 1 ;
SELECT nextval ('"price_types_price_type_id_se"');

Philip Jourdan

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message April L 2002-04-14 19:05:40 plpgsql and createlang?
Previous Message Josh Berkus 2002-04-14 18:25:46 Re: migration still a problem