search for: pgsql

Hi, I am trying to compile an application (PowerDNS) with PostgreSQL support. Where do the PowerDNS libraries get installed under CentOS? I am constantly getting the error checking for PgSQL library directory... configure: error: Didn't find the pgsql library dir in '/usr/include/lib/pgsql /usr/include/pgsql /usr/include' -- "I never look back darling, it distracts from the now", Edna Mode (The Incredibles)

Hello, I'm trying to use postgres authentication with dovecot on a linux system running Fedora Core 2. Installation of dovecot was done by installing the rpm included in the fedora distribution ("yum install dovecot"). from /etc/dovecot.conf auth_userdb = pgsql /etc/dovecot-pgsql.conf auth_passdb = pgsql /etc/dovecot-pgsql.conf but the logs tell me: dovecot: Jul 21 19:28:39 Info: Dovecot starting up dovecot-auth: Jul 21 19:28:40 Fatal: Unknown userdb type 'pgsql' dovecot: Jul 21 19:28:40 Error: Auth process died too early - shutting down dovecot:...

Plagued with an error I can't get past: ==> dovecot_info.log <== dovecot: Mar 04 22:09:06 Info: Dovecot starting up ==> dovecot.log <== dovecot-auth: Mar 04 22:09:07 Fatal: Can't open configuration file /usr/local/etc/dovecot-pgsql.conf: No such file or directory dovecot: Mar 04 22:09:07 Error: child 18211 (auth) returned error 89 dovecot: Mar 04 22:09:07 Error: Auth process died too early - shutting down pop3-login: Mar 04 22:09:07 Fatal: fd_send(-1) failed: Broken pipe I have dovecot (+ssl) configured on debian in a chroo...

I am having a problem with the configure script for Dovecot 1.0b8. It doesn't seem to be compiling in sql engine driver support. I have specified --with-sql and --with-pgsql but when the script is done it says "Building with SQL drivers ..............:" but lists no drivers afterwards. I tried compiling it anyway but it logs the error " auth(default): Unknown database driver 'pgsql' " so the it defiantly didn't get compiled in. My pgsq...

...Opteron 64 bit system. I need to run PHP4, Apache, and Postgres 8.1, but I'm having conflicts with Postgres 8.1 and PHP 4 that comes with CentOS. History: 1) I installed Apache and PHP with yum. 2) I then installed PostgreSQL 8.1 RPMs from the PG website. 3) Then, I tried to install php-pgsql with yum - and it didn't work, complaining about pgsql.so.3. So, I installed with --nodeps and symlinked the /usr/lib64/libpq.so.4 -> /usr/lib64/libpq.so.3. Now, PHP and PGSQL work without any problems. But now, I can't do a yum update - it still complains about pgsql.so.3! What c...

How do I find out who is the maintainer of the php-pgsql package, please? I want to request upgrade from underlying postgresql-libs-8.1.21 (/usr/lib64/libpq.so.4) to postgresql84-libs-8.4.4 (/usr/lib64/libpq.so.5.2). Background on this request: Apache httpd's php's php-pgsql uses PostgreSQL 8.1 library (/usr/lib64/libpq.so.4), which leaks memor...

I need to enable pg support on one of my CentOS servers. I know nothing about PHP but DRUPAL requires a DB backend and we have standardized on pg rather than mysql. The PHP.net page devoted to the subject of pg says that to enable pg support PHP must be built with the flag "--with-pgsql[=DIR]" and that the required support extension must be loaded via the /etc/php.ini file with the statement "extension=pgsql.so". However, I have tried to find this file "pgsql.so" on the CentOS server before proceeding blindly and have come up empty. Can somebody here giv...

Hello, I hope that this mailing list is "alive", since I am looking for a solution for my problem for a long time. I would like to migrate my existing dovecot installation from mysql to pgsql. But I have problems with the passwords when using pgsql. The existing and working mysql-based installation looks like this: dovecot-sql.conf.ext: driver = mysql default_pass_scheme = SHA512-CRYPT Users are created like this: INSERT INTO mls_user (idx,domain,password,email) VALUES (1,99,E...

Hello, does anybody know of a good source for a apr-util-pgsql rpm package for CentOS 5.6 / 64 bit and even more I'm curious why isn't it included but the apr-util-mysql is included... Thank you Alex

Hi: I'm running into a dependency problem when I try to install the php-pgsql package on CentOS 5.4 64bit. I have php 5.2.9 and when I try to do a yum install php-pgsql I get the following dep errors: Resolving Dependencies --> Running transaction check ---> Package php-pgsql.x86_64 0:5.1.6-23.2.el5_3 set to be updated --> Processing Dependency: php-common = 5.1.6-...

I get these errors : gem install pg -- --with-pgsql-include-dir=''/usr/include/pgsql'' -- with-pgsql-lib-dir=''/usr/lib/pgsql'' Building native extensions. This could take a while... ERROR: Error installing pg: ERROR: Failed to build gem native extension. /usr/bin/ruby extconf.rb --with-pgsql-include-dir=/usr/incl...

...on plan. The data on the source is not changing since it is snapshot of active data. Every time we try to run the following command: timex rsync -avuz --delete isynh09:/snap We get the following error: receiving file list ... done mknod "/d/snap/m01/server_metadata/postgresql/.s.PGSQL.5432" failed: Invalid argument mknod "/d/snap/m02/server_metadata/postgresql/.s.PGSQL.5432" failed: Invalid argument mknod "/d/snap/m03/server_metadata/postgresql/.s.PGSQL.5432" failed: Invalid argument mknod "/d/snap/m04/server_metadata/postgresql/.s.PGSQL.5432&quo...

...com/packages/dovecot/ and installed it. Now dovecot-auth isn't complaining anymore about an unknown userdb type but I can't get authentication working. /etc/dovecot.conf (...) # Authentication process name. auth = default # plain digest-md5 anonymous auth_mechanisms = plain auth_userdb = pgsql /etc/dovecot-pgsql.conf auth_userdb = pgsql /etc/dovecot-pgsql.conf auth_user = root auth_verbose = yes (...) /etc/dovecot-pgsql.conf connect = host=localhost dbname=xams-dovecot user=dovecot password=hallo default_pass_scheme = PLAIN password_query = SELECT password FROM users WHERE username = ...

I just upgraded R to version 2.4.0 and now I can't install packages RdbiPgSQL. I used the same procedure I did for previous versions of R ! Actually, last time I installed RdbiPgSQL day before upgrading but now I got: downloaded 27Kb * Installing *source* package 'RdbiPgSQL' ... creating cache ./config.cache checking for PQconnectdb in -lpq... no I could not find...

..."connect=" string of the SQL config. The documentation states that environment variables, being listed under global variables, work "everywhere": https://doc.dovecot.org/configuration_manual/config_file/config_variables/#variables-global However, the source code for driver-pgsql.c indicates that the connect string is never expanded: https://github.com/dovecot/core/blob/master/src/lib-sql/driver-pgsql.c#L297 For reference, this is my configuration. dovecot.conf: import_environment = PASSDB_USER PASSDB_DBNAME PASSDB_PASSWORD passdb { override_fields = proxy=...

hey all, I feel like I must be missing something rather plain, but I don't get it. how is one supposed to use R as a PgSQL client on Windows? Assume my windows desktop is on the same network as a PgSQL server, and I just need to use R to connect and pull down some data. The thing that is confusing me is that RODBC doesn't seem to know anything about PgSQL, in that odbcDataSources(type = "all") only ret...

Hi, We've been trying to set up a Samba 3 installation using a Postgresql backend with the passdb pgsql module. We compiled our own version of Samba 3.05 on Debian 3.0r1 after realizing the packages don't build the experimental backends by default. The Postgresql database is set up and working, but when attempting to add a new user using pdbedit, we keep getting this errors regarding "No I...

Dear All, Why does my configure fail like so: checking for pg_config... /usr/local/pgsql/8.2.4/bin/pg_config checking for PQexec in -lpq... no configure: *** configure: *** The PostgreSQL installation on this system appears to be broken. configure: *** Either correct the installation, or run configure configure: *** including --without-postgres Configure options are: env CC=/usr/loc...

Hi. I have installed php5 with support for postgresql (php5-pgsql). If I install postgresql-client ver. 8.2.7 or 8.3.x apache (httpd) core-dumps. If I install postgresql-client 8.1.11 or 8.2.6 apache does not core-dump. This is the output (backtrace) from gdb: (gdb) bt #0 0x000000080651c340 in ?? () #1 0x000000080094ebd5 in puts () from /lib/libc.so.7 #2 0x0...

...-g -O2 -c RS-PQescape.c -o RS-PQescape.o gcc -std=gnu99 -I/usr/local/lib64/R/include -DNDEBUG -I/usr/include -I/usr/local/include -fpic -g -O2 -c RS-PostgreSQL.c -o RS-PostgreSQL.o gcc -std=gnu99 -I/usr/local/lib64/R/include -DNDEBUG -I/usr/include -I/usr/local/include -fpic -g -O2 -c RS-pgsql-copy.c -o RS-pgsql-copy.o gcc -std=gnu99 -I/usr/local/lib64/R/include -DNDEBUG -I/usr/include -I/usr/local/include -fpic -g -O2 -c RS-pgsql-getResult.c -o RS-pgsql-getResult.o gcc -std=gnu99 -I/usr/local/lib64/R/include -DNDEBUG -I/usr/include -I/usr/local/include -fpic -g -O2 -c RS-pgsql...