[CentOS] relation "pg_user" does not exist error when running pg_dump
Andy Masiar
amasiar at gmail.com
Fri Apr 29 02:57:30 UTC 2005
Thank you for your replies.
First of all, this is not a new centos install, it has been running
quite reliably for some time until now. All posgresql packages are
stock centos and SELinux is disabled.
Also, my application is working fine, I can run queries against the
database. I get the error only when I'm trying to perform a backup to
move the data to another server. I can't init the db, I would lose my
data. I have backups from about 2 weeks ago but it would suck to have
to revert to them :-(
Andy
On 4/28/05, Alexander Dalloz <ad+lists at uni-x.org> wrote:
> Am Fr, den 29.04.2005 schrieb Alexander Dalloz um 2:37:
>
> > > # pg_dump -U postgres database > database.out
> > > pg_dump: SQL command failed
> > > pg_dump: Error message from server: ERROR: relation "pg_user" does not exist
> >
> > > Andy
> >
> > Above error is a result of a bug SELinux <--> PostgreSQL. There is a
> > bugzilla and in it's comments a way how to initialize PostgreSQL
> > correctly. I had the same issue with a fresh new CentOS 4 install.
> >
> > Alexander
>
> To complete my reply: the bugzilla ticket and the comment which I
> followed to successfully initiate the PostgreSQL server:
>
> https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=152591#c1
>
> Alexander
>
> --
> Alexander Dalloz | Enger, Germany | GPG http://pgp.mit.edu 0xB366A773
> legal statement: http://www.uni-x.org/legal.html
> Fedora Core 2 GNU/Linux on Athlon with kernel 2.6.11-1.14_FC2smp
> Serendipity 03:44:44 up 17 days, 25 users, load average: 0.16, 0.31,
> 0.37
>
>
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
>
>
>
>
More information about the CentOS
mailing list