postgres: import of previous dump fails

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I have been backing up my postgresql system with:

pg_dumpall >> ${NEW}

I now find that it will not import into postgresql on Fedora Core
1. The new version is postgresql-7.3.4-2, the old version is
7.2.3. When I try to import the old dump as user postgres, I see the
following:

--------------------------------------------------
-bash-2.05b$ cat pgdump.new | psql template1
You are now connected to database template1.
DELETE 0
CREATE USER
CREATE USER
ERROR:  user id must be positive
DELETE 0
You are now connected to database template1 as user postgres.
CREATE DATABASE
You are now connected to database apache as user postgres.
\connect: FATAL:  IDENT authentication failed for user "ccurley"
 
-bash-2.05b$
--------------------------------------------------

The top of the dump looks like so:

--------------------------------------------------
--
-- pg_dumpall (7.2.3)  
--
\connect template1
DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0');

CREATE USER "ccurley" WITH SYSID 500 CREATEDB NOCREATEUSER;
CREATE USER "apache" WITH SYSID 48 NOCREATEDB NOCREATEUSER;
CREATE USER "root" WITH SYSID 0 NOCREATEDB NOCREATEUSER;

DELETE FROM pg_group;


--
-- Database apache
--
\connect template1 "postgres"
CREATE DATABASE "apache" WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII';
\connect "apache" "postgres"
--
-- Selected TOC Entries:
--

--
-- Database ccurley
--
\connect template1 "ccurley"
CREATE DATABASE "ccurley" WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII';
\connect "ccurley" "ccurley"
--
-- Selected TOC Entries:
--
--------------------------------------------------


I didn't see anything useful at http://www.postgresql.org.


-- 

Charles Curley                  /"\    ASCII Ribbon Campaign
Looking for fine software       \ /    Respect for open standards
and/or writing?                  X     No HTML/RTF in email
http://www.charlescurley.com    / \    No M$ Word docs in email

Key fingerprint = CE5C 6645 A45A 64E4 94C0  809C FFF6 4C48 4ECD DFDB

Attachment: pgptIt03ewd9i.pgp
Description: PGP signature


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux