pg_dumpall troubles

Поиск
Список
Период
Сортировка
От Valerio Santinelli
Тема pg_dumpall troubles
Дата
Msg-id 37134BFE.58470913@mediacom.it
обсуждение исходный текст
Список pgsql-general
I'm experiencing a weird problem with pgdump_all trying to dump a
database running under PostGreSQL v6.4.2
I'm attaching the dump to this message (it's not that big because it
gets struck almost instantly :) )

C'ya

Valerio Santinelli
tanis@mediacom.it

\connect template1
select datdba into table tmp_pg_shadow       from pg_database where datname = 'template1';
delete from pg_shadow where usesysid <> tmp_pg_shadow.datdba;
drop table tmp_pg_shadow;
copy pg_shadow from stdin;
root    0    t    t    t    t    \N    \N
uox    1003    f    t    f    t        \N
tanis    1000    f    t    f    t    tanis    \N
\.
\connect template1 postgres
create database radiusd;
\connect radiusd postgres
CREATE SEQUENCE "login_id_seq" start 2593 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('login_id_seq');
CREATE SEQUENCE "clienti_id_seq" start 1783 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('clienti_id_seq');
CREATE SEQUENCE "fatture_id_seq" start 1784 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('fatture_id_seq');
CREATE SEQUENCE "oggetti_id_seq" start 3 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "pagamenti_id_seq" start 7 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "tipicontratti_id_seq" start 31 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "vocifatture_id_seq" start 3083 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('vocifatture_id_seq');
CREATE TABLE "users" (
    "pass" character varying(16),
    "username" character varying(8));
CREATE TABLE "logs" (
    "bwin" int4,
    "bwout" int4,
    "name" character varying(32),
    "start" datetime,
    "stop" datetime);
CREATE TABLE "loginBACKUP" (
    "ID" int4,
    "IDC" int4,
    "Login" character varying(50),
    "Nota" text,
    "Attivazione" datetime,
    "Disattivazione" datetime,
    "Importo_pagato" float8,
    "Demo" character,
    "Lasciare" character,
    "Notalasciare" character varying(50),
    "Tipo" character varying(100),
    "Disattivato" character,
    "Fatturato" character);
CREATE TABLE "pgadmin_sys" (
    "id" int2 DEFAULT '1',
    "tracking" "char" DEFAULT 'N',
    "version" float4 DEFAULT '1.0');
CREATE TABLE "pgadmin_log" (
    "event_date" date,
    "username" name,
    "version" float4,
    "query" text);
CREATE TABLE "login" (
    "id" int4 DEFAULT nextval('login_id_seq') NOT NULL,
    "idc" int4,
    "login" character varying(50),
    "nota" text,
    "attivazione" datetime,
    "disattivazione" datetime,
    "importo_pagato" float8,
    "demo" int2,
    "lasciare" int2,
    "notalasciare" character varying(50),
    "tipo" character varying(100),
    "disattivato" int2,
    "fatturato" int2,
    "numeroc" character varying(50),
    "datanascita" datetime,
    "tipodoc" character varying(20),
    "numerodoc" character varying(30),
    "nemail" int2,
    "costoemail" float8,
    "email2" character varying(20),
    "email3" character varying(20),
    "email4" character varying(20),
    "email5" character varying(20),
    "kwebc" int2,
    "kwebnc" int2,
    "costoweb" float8);
CREATE TABLE "clienti" (
    "id" int4 DEFAULT nextval('clienti_id_seq') NOT NULL,
    "idcliente" character varying(50),
    "nome" character varying(50),
    "ditta" character varying(50),
    "indirizzo" character varying(254),
    "partitaiva" character varying(20),
    "tel" character varying(50),
    "nota" text);
CREATE TABLE "fatture" (
    "id" int4 DEFAULT nextval('fatture_id_seq') NOT NULL,
    "numerof" character varying(50),
    "data" datetime,
    "idc" int4,
    "pagamento" character varying(50),
    "condizioni" character varying(100),
    "oggetto" character varying(254),
    "iva" int2);
CREATE TABLE "oggetti" (
    "id" int4 DEFAULT nextval('oggetti_id_seq') NOT NULL,
    "oggetto" character varying(50));
CREATE TABLE "pagamenti" (
    "id" int4 DEFAULT nextval('pagamenti_id_seq') NOT NULL,
    "paga" character varying(50));
CREATE TABLE "tipicontratti" (
    "id" int4 DEFAULT nextval('tipicontratti_id_seq') NOT NULL,
    "tipo" character varying(254),
    "importo" float8);
CREATE TABLE "vocifatture" (
    "id" int4 DEFAULT nextval('vocifatture_id_seq') NOT NULL,
    "idfattura" int4,
    "quantita" int4,
    "descrizione" character varying(254),
    "importo" float8,
    "totale" float8);
CREATE FUNCTION "msaccessbool" (bool,int4 ) RETURNS bool AS '-' LANGUAGE 'INTERNAL';
CREATE FUNCTION "bool2int" (bool ) RETURNS int2 AS 'SELECT int2(-1) WHERE $1 UNION SELECT int2(0) WHERE
 NOT $1' LANGUAGE 'SQL';

В списке pgsql-general по дате отправления:

Предыдущее
От: José Soares
Дата:
Сообщение: Re: [GENERAL] leap day bug after 1901
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: [HACKERS] Re: [GENERAL] leap day bug after 1901