BUG #5148: Email to pgsql-bugs@postgresql.org bounces: - Mailing list pgsql-bugs

From Jonathan Hayward
Subject BUG #5148: Email to pgsql-bugs@postgresql.org bounces:
Date
Msg-id 200910292119.n9TLJwXj012740@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5148: Email to pgsql-bugs@postgresql.org bounces:
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5148
Logged by:          Jonathan Hayward
Email address:      jonathan.hayward@pobox.com
PostgreSQL version: 8.1.x
Operating system:   Gentoo
Description:        Email to pgsql-bugs@postgresql.org bounces:
Details:

I sent the following email:

BEGIN QUOTE




MIME-Version: 1.0
Received: by 10.239.153.136 with HTTP; Thu, 29 Oct 2009 14:14:42 -0700
(PDT)
Date: Thu, 29 Oct 2009 16:14:42 -0500
Delivered-To: christos.jonathan.hayward@gmail.com
Message-ID: <fdc31b650910291414n269ef5afj68fd090c0f7df2b0@mail.gmail.com>
Subject: Can't create database on 8.1.x
From: Jonathan Hayward <christos.jonathan.hayward@gmail.com>
To: pgsql-bugs@postgres.org
Content-Type: multipart/alternative; boundary=001485f5b10863a7e8047719663f

--001485f5b10863a7e8047719663f
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I am trying to populate a database from a fresh install under Gentoo. There
had been an earlier database, and to get a clean slate I wiped
/var/lib/postgresql, then ran:

# emerge postgresql --config
# /etc/init.d/postgresql start
# rc-update add postgresql default

So far, so good (the first command populated a new /var/lib/postgresql),
bu=
t
when I then ran,

# createdb -U postgres scope

I get:

createdb: could not connect to database postgres: FATAL:  could not open
file "global/pg_database": No such file or directory

A Google search for 'createdb: could not connect to database postgres:
FATAL:  could not open file "global/pg_database": No such file or
directory'turns up various hosts' versions of a mailing list thread
where someone
reported the error and the only reply was a Postgres consultant saying that
sounded strange and asking about $PGDATA (after which I tried setting
PGDATA=3D/var/lib/postgresql/data and got the same error). One instance of
this thread is at
http://markmail.org/message/w4vaaatfzrkmw64d#query:createdb%3A%20could%20no=

t%20connect%20to%20database%20postgres%3A%20FATAL%3A%20could%20not%20open%2=

0file%20global%2Fpg_database%3A%20No%20such%20file%20or%20directory+page:1+=

mid:p43xt7ykf3pd57xn+state:results

I want to try a different version to see if I can circumvent the problem
that way, but do you have any suggestions?

--=20
=E2=86=92 Jonathan Hayward, christos.jonathan.hayward@gmail.com
=E2=86=92 An Orthodox Christian author: theology, literature, et cetera.
=E2=86=92 My award-winning collection is available for free reading online:
=E2=98=A9 I invite you to visit my main site at http://JonathansCorner.com/

--001485f5b10863a7e8047719663f
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I am trying to populate a database from a fresh install under Gentoo.
There=
 had been an earlier database, and to get a clean slate I wiped
/var/lib/po=
stgresql, then ran:<br><br># emerge postgresql --config<br>#
/etc/init.d/po=
stgresql start<br>
# rc-update add postgresql default<br><br>So far, so good (the first
comman=
d populated a new /var/lib/postgresql), but when I then ran,<br><br>#
creat=
edb -U postgres scope<br><br>I get:<br><br>createdb: could not connect to
d=
atabase postgres: FATAL:=C2=A0 could not open file "g<span
class=3D"f7=
 b0">lobal/pg<span class=3D"underscore">_</span>database": No such
fil=
e or directory</span><br clear=3D"all">
<br>A Google search for 'createdb: could not connect to database
postgr=
es: FATAL:=C2=A0 could not open file "g<span class=3D"f7
b0">lobal/pg<=
span class=3D"underscore">_</span>database": No such file or
directory=
'</span> turns up various hosts' versions of a mailing list thread
=
where someone reported the error and the only reply was a Postgres
consulta=
nt saying that sounded strange and asking about $PGDATA (after which I
trie=
d setting PGDATA=3D/var/lib/postgresql/data and got the same error). One
in=
stance of this thread is at <a
href=3D"http://markmail.org/message/w4vaaatf=
zrkmw64d#query:createdb%3A%20could%20not%20connect%20to%20database%20postgr=

es%3A%20FATAL%3A%20could%20not%20open%20file%20global%2Fpg_database%3A%20No=

%20such%20file%20or%20directory+page:1+mid:p43xt7ykf3pd57xn+state:results">=

http://markmail.org/message/w4vaaatfzrkmw64d#query:createdb%3A%20could%20no=

t%20connect%20to%20database%20postgres%3A%20FATAL%3A%20could%20not%20open%2=

0file%20global%2Fpg_database%3A%20No%20such%20file%20or%20directory+page:1+=

mid:p43xt7ykf3pd57xn+state:results</a><br>
<br>I want to try a different version to see if I can circumvent the
proble=
m that way, but do you have any suggestions?<br><br>-- <br>=E2=86=92
Jonath=
an Hayward, <a
href=3D"mailto:christos.jonathan.hayward@gmail.com">christos=
.jonathan.hayward@gmail.com</a><br>
=E2=86=92 An Orthodox Christian author: theology, literature, et
cetera.<br=
>=E2=86=92 My award-winning collection is available for free reading
online=
:<br>=E2=98=A9 I invite you to visit my main site at <a
href=3D"http://Jona=
thansCorner.com/">http://JonathansCorner.com/</a><br>


--001485f5b10863a7e8047719663f--
END QUOTE

It bounced almost immediately:

BEGIN QUOTE




Delivered-To: christos.jonathan.hayward@gmail.com
Received: by 10.239.153.136 with SMTP id z8cs200506hbb;
        Thu, 29 Oct 2009 14:14:46 -0700 (PDT)
Received: by 10.239.145.33 with SMTP id q33mr80862hba.126.1256850886015;
        Thu, 29 Oct 2009 14:14:46 -0700 (PDT)
Return-Path: <>
Received: by 10.239.145.33 with SMTP id q33mr108019hba.126;
        Thu, 29 Oct 2009 14:14:46 -0700 (PDT)
Message-ID: <001485f7918098b9560477196610@googlemail.com>
From: Mail Delivery Subsystem <mailer-daemon@googlemail.com>
To: christos.jonathan.hayward@gmail.com
Subject: Delivery Status Notification (Failure)
Date: Thu, 29 Oct 2009 14:14:46 -0700 (PDT)
X-Failed-Recipients: pgsql-bugs@postgres.org

This is an automatically generated Delivery Status Notification

Delivery to the following recipient failed permanently:

     pgsql-bugs@postgres.org

Technical details of permanent failure:
Google tried to deliver your message, but it was rejected by the recipient
domain. We recommend contacting the other email provider for further
information about the cause of this error. The error that the other server
returned was: 554 554 5.7.1 <pgsql-bugs@postgres.org>: Relay access denied
(state 14).

   ----- Original message -----

MIME-Version: 1.0
Received: by 10.239.145.33 with SMTP id q33mr80858hba.126.1256850882624;
Thu,
    29 Oct 2009 14:14:42 -0700 (PDT)
Date: Thu, 29 Oct 2009 16:14:42 -0500
Message-ID: <fdc31b650910291414n269ef5afj68fd090c0f7df2b0@mail.gmail.com>
Subject: Can't create database on 8.1.x
From: Jonathan Hayward <christos.jonathan.hayward@gmail.com>
To: pgsql-bugs@postgres.org
Content-Type: multipart/alternative; boundary=001485f7918064fcca0477196600

--001485f7918064fcca0477196600
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I am trying to populate a database from a fresh install under Gentoo. There
had been an earlier database, and to get a clean slate I wiped
/var/lib/postgresql, then ran:

# emerge postgresql --config
# /etc/init.d/postgresql start

   ----- Message truncated -----

END QUOTE

pgsql-bugs by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: BUG #5148: Email to pgsql-bugs@postgresql.org bounces: