Dnia piątek, 11 lipca 2008, Tom Lane napisał: > "Michal Szelag" <[EMAIL PROTECTED]> writes: > > i have a server crash by retoring database. > > > > I try to retore my database from a custom package with pg_restore and > > prom a plain package with psql. In both i have the same problem, psl and > > pg_restore outputs: > > pg_restore: [archiver (db)] error returned by PQputCopyData: server > > closed the connection unexpectedly > > You're evidently tripping over some kind of bug, but we can't help you > without a lot more detail than this. Try to identify the exact command > that's crashing (hint: turn on log_statements and watch the postmaster > log). See if you can put together a self-contained script that causes > the crash. That will let us fix the problem, and it might let you find > a workaround to reload your data even in advance of a real fix. > > regards, tom lane
Hallo, the crash occurs by this command in my dump: COPY users_history (users_history_id, users_id, uh_date, uh_php_session_id, uh_gpsc, uh_ip, uh_browser, uh_referer, uh_url) FROM stdin; so, i excluded this table from my dump and the same error occurs by this command: ALTER TABLE ONLY invoices_lines ADD CONSTRAINT invoices_lines_pkey PRIMARY KEY (nagid, o, linid); The plain dump of my database has size of 4GB. I have divided my dump with head, tail, grep, dd, etc. and i have restored my database(a have spend a lot of time by this). Best regerds, Michał Szeląg. -- ================================== Michał Szeląg tel.: +48 693 11 37 55 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
