Re: [GENERAL] Phantom groups

2006-07-04 Thread Chris
Carlos H. Reimer wrote: Hi, I´m planning to migrate from 7.4 to 8.0.7 and I discovered some strange behavior during migration. pg_dump inserted GRANT to phantom groups. They do not exist in pg_group; When the script created by pg_dump is processed by psql during restore, these GRANTs produce a

Re: [GENERAL] Automatic Installer

2006-07-04 Thread Chris
Joko Siswanto wrote: Hi All, How to make the postgresql and application setup installer automatic. for example, I want to make a demo software for averyone but of course they want easy way. Just klik2 and the apllication software is ready to use. Note: This is for desktop application made by

Re: [GENERAL] Backing up and restoring a database with the SELinux pg_user problem.

2006-07-04 Thread Joseph Kiniry
Hi Tom, Thank you for the very quick response. I'll let Robin followup on this for tonight, as I'm heading to bed after a very long day. On 4 Jul, 2006, at 22:12, Tom Lane wrote: Joseph Kiniry <[EMAIL PROTECTED]> writes: As I said above, I have re-examined, and executed if necessary, by h

Re: [GENERAL] Backing up and restoring a database with the SELinux pg_user problem.

2006-07-04 Thread Tom Lane
Joseph Kiniry <[EMAIL PROTECTED]> writes: > As I said above, I have re-examined, and executed if necessary, by > hand, all sql commands in initdb and postgres.bki, but it seems that > pg_catalog is still screwed up. Attempting to dump, or perform > several other actions results in failures o

Re: [GENERAL] Backing up and restoring a database with the SELinux pg_user problem.

2006-07-04 Thread Joseph Kiniry
Hi all, Returning to a really old problem that is biting me again... We upgraded our server (from Fedora Core 3 to Core 5), and thus upgraded Postgres. Unfortunately, we did not know that the new version of Postgres included with 5 uses a different data format than that included with 3.

[GENERAL] OLEDB connection does not want to work. Help!!

2006-07-04 Thread tommaso . gastaldi
Hi all, I am pulling my hair trying to make work an OLEDB connection to POSTGRES. Let me anticipate that, except for the connection string I am using the same code (VB.NET, Oledb) that has already proved to work fine with all the following systems: sqlserver, Mysql, db2, access, Oracle [to say al

Re: [GENERAL] High-Availability Question

2006-07-04 Thread ProAce
> First idea: > I install the pgpool on each web server (the web server farm include > 16 web servers), and configure the pgpool as replication mode. The web > application (written by php) access to the db server through the local > pgpool daemon. > The idea sounds a little unusual, dose it seems

Re: [GENERAL] pgsql user change to postgres

2006-07-04 Thread Ian Harding
I wasn't trying to fight it. It's just that the port disagrees with the PG documentation and apparently most other ports. The maintainer said it was for backward compatibility but it's apparently only a FreeBSD "phenomenom" :-) It may be a *BSD pheonomenon, since I know it applies in NetBSD as

[GENERAL] How to bypass perm pb on information schema. Request of review

2006-07-04 Thread Sandro Dentella
Hi list, since up to now information_schema is pretty 'severe' in giving info that can be retrieved easily using '\d'or '\d table_name', I tried to write some queries for sqlalchemy (the ORM for python) to make it work correctly. I used "psql -E + \d" to spy how postgresql retrieved the i

[GENERAL] Postgres & CODA

2006-07-04 Thread Rivera Alejandro
I've been reading a lot of documentation trying to find a way to implement a Postgres database on CODA and get it distributed that way. Unfortunately, I found out that CODA apparently doesn't support concurrency over databases, so i came up with an idea of using files, each file containing a sin

Re: [GENERAL] RAID + PostgreSQL?

2006-07-04 Thread Joshua D. Drake
On Tuesday 04 July 2006 00:40, [EMAIL PROTECTED] wrote: > If you need so much performance and space you will need an external storage > extensions (how about SAN) > or HP ML 570 G4 (up to 18 hpt plug SFF Drives) with Intel 7041 CPUs ? Or you could be a little more thrifty and go with the ml30 whic

Re: [GENERAL] php can't connect to postgresql server

2006-07-04 Thread Clodoaldo Pinto
2006/7/3, Clodoaldo Pinto <[EMAIL PROTECTED]>: 2006/7/3, Clodoaldo Pinto <[EMAIL PROTECTED]>: > php can't connect to postgresql server > > php error log message: > > PHP Warning: pg_connect() [ href='function.pg-connect'>function.pg-connect]: Unable to connect > to PostgreSQL server: could not c

Re: [GENERAL] RAID + PostgreSQL?

2006-07-04 Thread Franz . Rasper
Title: Nachricht If you need so much performance and space you will need an external storage extensions (how about SAN) or HP ML 570 G4 (up to 18 hpt plug SFF Drives) with Intel 7041 CPUs ?   Greetings,   -Franz -Ursprüngliche Nachricht-Von: Alex Turner [mailto:[EMAIL PROTEC

Re: [GENERAL] High-Availability Question

2006-07-04 Thread Ivan Zolotukhin
Hello, > Third idea: > I install the Slony-I, linux-ha and postgresql on the same server of > the two 2U servers. The web application access to the db server > directly and without pgpool. AFAIK, Slony does not have failover capabilities you need in HA solution: http://gborg.postgresql.org/pr