On Mon, 2003-12-08 at 13:54, Charles Curley wrote:
> 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.
First off, check to be sure that identd service is running on your
machine. Second, be sure that there is a user named ccurley on the box.
--
Edward M. Croft
Sr. Systems Engineer
Open Ratings, Inc.
200 West Street
Waltham, MA 02451-1121
