pg_dumpall troubles - Mailing list pgsql-general

From Valerio Santinelli
Subject pg_dumpall troubles
Date
Msg-id 37134BFE.58470913@mediacom.it
Whole thread Raw
List 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 by date:

Previous
From: José Soares
Date:
Subject: Re: [GENERAL] leap day bug after 1901
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] Re: [GENERAL] leap day bug after 1901