Re: [ADMIN] mls selinux and postgres

2011-04-09 Thread Craig James
On 4/9/11 9:24 AM, H S wrote: Dear Sirs, I would like to include SELINUX MLS to my postgres DBMS, I have just install mls package on my fedora 14 and mcstrans But after relabelling my whole file system, I do not have any graphical user interface , and must login to my system in text mode (

[ADMIN] mls selinux and postgres

2011-04-09 Thread H S
Dear Sirs, I would like to include SELINUX MLS to my postgres DBMS, I have just install mls package on my fedora 14 and mcstrans But after relabelling my whole file system, I do not have any graphical user interface ,  and must login to my system in text mode (runlevel 3).  Is there anyone

Re: [ADMIN] 20110408pg upgrade fix: How do I know if I am being affected before errors occur

2011-04-09 Thread Stephen Frost
Erwin, * Erwin Brandstetter (brsaw...@gmail.com) wrote: > - Can applying the proposed fix break anything if the db wasn't > affected to begin with? Running a database-wide 'vacuum freeze;' will either succeed (and all will be well), or it'll generate the errors in the message (in which case you'

[ADMIN] 20110408pg upgrade fix: How do I know if I am being affected before errors occur

2011-04-09 Thread Erwin Brandstetter
Hello! In connection with the recently discovered bug with pg_upgrade: http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix If I an not sure whether pg_upgrade or pg_migrate has been applied on certain databases in the past: - How do I know if I am being affected by the bug _before_ errors occ

[ADMIN] Using postgresql with (filesystem) ACLs in linux.

2011-04-09 Thread toomanyryans
Hi, I'm trying to install PostgreSQL using the packages from here: http://www.openscg.org/se/postgresql/packages.jsp Those bundles are very close to the way I like to install things on my continuous integration server. However, I use an ACL enabled filesystem (to simplify backups). PostgreSQL

Re: [ADMIN] DB Import Error...

2011-04-09 Thread Marcelo Leite
Sorry... when i said "search for the problematic constraint" i meant to open the file in a text editor and search for the problematic constraint. MLeite

Re: [ADMIN] DB Import Error...

2011-04-09 Thread Marcelo Leite
Hi, even getting this error, do you have the database restored? Have you tried to dump only the schema (without data) and search for the problematic constraint to check if you have 2 or more with same name? Regards, MLeite