Re: [GENERAL] postgres 9.3

On 7/31/2015 9:39 AM, Ramesh T wrote: -bash-4.1$ service postgres-9.3 start postgres-9.3: unrecognized service on redhat/centos type systems, the service name is postgresql-9.3 note that the service command is meant to be run by the root user, a $ prompt in bash generally indicates you're not

Re: [GENERAL] postgres 9.3

On 07/31/2015 09:39 AM, Ramesh T wrote: I changed archive_command in postgresql.conf and restarted it.postgres 3 installed on linux.connected from putty. There is no Postgres 3, but given your comments below I going to go on the assumption you are talking about 9.3. What Linux distribution a

[GENERAL] postgres 9.3

I changed archive_command in postgresql.conf and restarted it.postgres 3 installed on linux.connected from putty. after restarted it getting message like -bash-4.1$ service postgres-9.3 start postgres-9.3: unrecognized service but files available at server side.. any help..?

Re: [GENERAL] PLPerl Trigger to update text search

On Fri, Jul 31, 2015 at 7:15 PM, Alex Hunsaker wrote: > > > > $_TD->{new}{text_search} = > spi_exec_query("to_tsvector('pg_catalog.english', ". quote_literal('text1 > text2') .";")->{rows}[0]{to_tsvector}; > > Err that should be: (still untested, was missing the "select" bit) $_TD->{new}{text_se

Re: [GENERAL] PLPerl Trigger to update text search

On Fri, Jul 31, 2015 at 6:07 AM, Alex Magnum wrote: > Hi, > > I am trying to update a tsvector field through a plperl trigger. > > $_TD->{new}{text_search} = to_tsvector('pg_catalog.english', 'text1 > text2'); > > You need to wrap that into an actual SPI call at the very least. Database procedure

Re: [GENERAL] conn = PQconnectdb(conninfo);

Hi Laurenz, I'm not using ssl at the moment. The thing is when the reachable leak is there is just grows. It is not constant. And at a given point the program will break. I've ran the program with: valgrind --leak-check=full --show-reachable=yes --log-file="_pg_test_debug.log" ./_pg_test_debug V

[GENERAL] PLPerl Trigger to update text search

Hi, I am trying to update a tsvector field through a plperl trigger. $_TD->{new}{text_search} = to_tsvector('pg_catalog.english', 'text1 text2'); but plperl does not seem to like that... ERROR: Undefined subroutine &main::to_tsvector called anyone done that and could help me out if that is act

Re: [GENERAL] Backup fatal issue

Hi all, I am continuing to investigate and I found a probable malfunctioning in linux semaphores: I foud postgres semaphores are deleted during barman backup process. To executing test I have created a new empty postgres cluster in a Debian Citrix virtual machine; this is output of ipcs -s command:

[GENERAL] multiple postgres processes after establishing tcp connection

Hello, PostgreSQL 9.4.4 started in usual way > [postgres@ubuntu12-vm][20150731 06:26:06]:/db2/master$ pg_ctl start -D > /db2/master/ -l serverlog > server starting I can see root process for this then: > [postgres@ubuntu12-vm][20150731 06:38:36]:/db2/master$ ps -ef | grep >

Re: [GENERAL] conn = PQconnectdb(conninfo);

Peter Kroon wrote: > I've found perhaps a bug. > I've narrowed down my code and the problem is indeed at: conn = > PQconnectdb(conninfo); > > My connection string: host=192.168.178.12 dbname=DATABASE user=foo > password=bar > > When I remove key/value host=xxx then everything is OK. Valgrind me