similar to: How to add Postgresql user & pasword details

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 memory. PostgreSQL 8.4 library does not leak.

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

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 0x000000080094f1ee in gethostbyname

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

Good day, I am having trouble getting dovecot to authenticate using postgresql. For some reason, it fails on a PAM error, although I have specified pgsql as authentication? Here my setups: dovecot.conf: -- snip-- (not sure if you need teh rest) auth = digest_md5 auth_mechanisms = plain digest-md5 auth_userdb = pgsql /etc/dovecot-pgsql.conf auth_passdb = pgsql /etc/dovecot-pgsql.conf auth_user

Dear all, I'm trying to get last_login plugin working with PostgreSQL, but seems Dovecot doesn't handle duplicate key while updating last login time (note: same setting works fine with MariaDB). I wonder whether it's a bug of Dovecot or i should handle this with PostgreSQL trigger. OS: OpenBSD 6.4 (amd64) Dovecot: 2.2.36 PostgreSQL: 10.5 Error log: ################### Mar 31

I''ve been reading the RoR tutorials and wiki help stuff, but I''m stuck. :( I''ve got RoR installed properly and get the "Welcome aboard! You''re riding the rails." I have an "article" controller, "article" model, and both an "article" and "articles" views (one is a remnant, I think, and no longer needed) (the

i have installed database POSTGRESQL for storing call details. when i restart database i get the error. [root at localhost server]# psql -h 127.0.0.1 -U asterisk Password psql: could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? THIS IS MY /VAR/LIB/PGSQL/DATA/POSTGRESQL.CONF # CONNECTIONS AND

ok, so I removed the default postgresql install and installed it from the software collections.. following the instructions at https://www.softwarecollections.org/en/scls/rhscl/rh-postgresql95/ and I get this [root at home1p /home/jason]$scl enable rh-postgresql95 bash [root at HOME1P jason]# postgresql-setup --initdb * Initializing database in

I have discovered that the default init script distributed with pgsql v8.1 sets the listening port to 5432 but does not enable tcp/ip connections. One must add the -i switch to the invocation line in the script. I am not sure if this is an oversight or whether there is another way to tell postmaster to start with tcp/ip listening enabled that I am unaware of. However, I thought that this

Hi, I am using postgresql for my password and user databases. The problem is, that the information needed in the user database is held in more than one table. But it seems to me that dovecot expects to get all the information for mailbox, uid, gid and home in _one_ query. Is there a way to get around this? Maybe even getting some of this information by another way than pgsql (this is more a

Hi All, I am trying to run rsync from HP11.00 machine (source) to HP11.11 machine, as test for migration 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

Hello list. Does anybody of you use PHP 5.0.4 from "CentOS plus" repo and PostgreSQL 8.1.x from www.postgresql.org (rpms for RHLE 4 AS)? (php-pgsql.rpm I have installed) On my machine PHP don't connect to PostgreSQL. Anybody of you set it up? On the other server I use PHP and PostgreSQL included into CentOS 4.x and it works fine. Regards. --

Hi list, I'm new to Centos and I've a very small knowledge of selinux use. I can disable it, but I prefer take it on for study. I've a second mirrored device that I use for file sharing. This is the scenario: /dev/md2 mounted on /mnt/data To make samba working I must set the file context to the path at samba_share_t on /mnt/data. After this samba works. Now I'm setting up

I am currently facing the following log output: Apr 26 16:40:28 h2290750 dovecot: auth: Error: pgsql(localhost): Connect failed to database mail: could not connect to server: Permission denied Apr 26 16:40:28 h2290750 dovecot: auth: Error: #011Is the server running on host "localhost" (::1) and accepting Apr 26 16:40:28 h2290750 dovecot: auth: Error: #011TCP/IP connections on port 5432?

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

Hi Folks, CentOS 5.5 - Postgresql 8.4 Installed - startet try to createuser -d- -a -p username get message could not connect to server: Connection refused Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.0"? postrgesql.conf has line listen_addresses = '192.168.0.2' Why sockets (in /tmp are s.PGSQL.5431 )

Hi all, I'm trying to install an add-on package for R called RPgSQL. Its role will be to link R with a PostgreSql database. I work on a Linux machine. However, I'm quite a newbie as far as R's concerned, and I don't manage to install the package properly. That's the steps I followed : * downloading the package (archive) * R CMD INSTALL /path/to/package.tar.gz (as

Dear All, I am working with linear mixed-effects models using the lme4 package in R. I created a model with the lmer function including some main effects, a two-way interaction and a random effect. Now I am searching how I could incorporate an interaction between the random effect and one of the fixed effects. I tried to express the interaction in:

Hello, I am trying to install RPostgreSQL, but without success at the moment, getting an errormessage - see below. My OS is Fedora 17, R version 2.15.2, PostgreSQL 9.2.1 with Postgis 2.0.1 spatial extension. Thank You for any help, advice or hint in advance. Regards Tomas > install.packages("RPostgreSQL", dependencies=TRUE) trying URL