[GENERAL] PostgreSQL and iptables

Hi there, I am trying to install a postgres cluster in a XenSever VM: I did not have any difficulties in compiling, installing and starting the DB. The problem is that I can not access to this db from an external machine: I tried to configure port forwarding through iptables as well as I did for ss

Re: [GENERAL] PostgreSQL and iptables

ba.conf on the PostgreSQL server > and then reload the PostgreSQL cluster. IE: pg_ctl reload > > On Fri, Jun 12, 2015 at 10:58 AM, mephysto > wrote: > >> Hi there, >> I am trying to install a postgres cluster in a XenSever VM: I did not have >> any difficulties in

Re: FW: [GENERAL] PostgreSQL and iptables

ecifcally add the ip's to > the pg_hba.conf on the PostgreSQL server > > > and then reload the PostgreSQL cluster. IE: pg_ctl reload > > > > Generally, yes. But the original poster’s error message said “No route to > host,” this is not pg_hba.conf-related. >

Re: FW: [GENERAL] PostgreSQL and iptables

Many thanks to all, I resolved my issue. A rules has lacked in iptables, like this: iptables -A INPUT -p tcp --dport 5997 -j ACCEPT Bye. Meph -- View this message in context: http://postgresql.nabble.com/PostgreSQL-and-iptables-tp5853587p5854028.html Sent from the PostgreSQL - general maili

[GENERAL] Backup fatal issue

Hi there, I have some problems in a postgres cluster when I try to execute a backup. This is the log of entire operation: LOG: connection received: host=91.121.182.110 port=54957 LOG: connection authorized: user=postgres database=postgres LOG: statement: BEGIN LOG: statement: SET application_n

Re: [GENERAL] Backup fatal issue

s started? > > > > On Fri, Jul 17, 2015 at 3:29 AM, mephysto > wrote: > >> Hi there, >> I have some problems in a postgres cluster when I try to execute a backup. >> This is the log of entire operation: >> >> LOG: connection received: host=91.121.182.

Re: [GENERAL] Backup fatal issue

ing with Barman, try doing a manual backup. > IE: pg_dump your_database > /tmp/somefile.sql > > If that works, then the problem is with Barman or it's configuration. > > On Fri, Jul 17, 2015 at 10:07 AM, Mephysto > wrote: > >> Hi Melvin, >> I am using Pstgre

Re: [GENERAL] Backup fatal issue

Hi Tom, I am using only pg_ctl to start and stop my database. At the moment I do not use any script. Bye. Meph On 17 July 2015 at 16:32, Tom Lane wrote: > mephysto writes: > > I have some problems in a postgres cluster when I try to execute a > backup. > > ... > >

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] Partitioning table by multiple columns

Hi there, I need to partition a table by value of two columns: id_1 and id_2. They are both bigint. Anyone have experience in this? Anyone know how can I do this partitioning? Thanks in advance. Meph -- View this message in context: http://postgresql.nabble.com/Partitioning-table-by-multipl

[GENERAL] Temporary table already exists

aused issue is exactly my temporary table. My question is: what is the reason for which I take this type of error? Is there a way to follow to avoid this situation? Thanks in advance. Mephysto -- View this message in context: http://postgresql.1045698.n5.nabble.com/Temporary-table-already-exists-

Re: [GENERAL] Temporary table already exists

Hi Albe,this is code of my stored function:ConnectionPool reuse connections, of course, but how you can see from my code, the temporary table deck_types are already defined with ON COMMIT DROP clause, so I think that my work is not in transaction. Am I true?If so, how can I put my code in transacti

Re: [GENERAL] Temporary table already exists

Thank you Felix, but I would to create temporary table from stored procedure, non from application code. Thanks again. Meph -- View this message in context: http://postgresql.1045698.n5.nabble.com/Temporary-table-already-exists-tp5789852p5789877.html Sent from the PostgreSQL - general mailing

Re: [GENERAL] Temporary table already exists

Dmitriy Igrishin wrote > 2014-01-31 Albe Laurenz < > laurenz.albe@.gv > >: > >> mephysto wrote: >> > Hi Albe, this is code of my stored function: >> > CREATE OR REPLACE FUNCTION :FUNCTION_SCHEMA.get_deck_types >> [...] >> >

Re: [GENERAL] Temporary table already exists

Hello newly, this is my error log: Thanks in advance. Meph -- View this message in context: http://postgresql.1045698.n5.nabble.com/Temporary-table-already-exists-tp5789852p5790682.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general maili

Re: [GENERAL] Temporary table already exists

Ehm no, at a few line befor end you can read this: ERROR: relation "deck_types" already exists So, the error persists. :( -- View this message in context: http://postgresql.1045698.n5.nabble.com/Temporary-table-already-exists-tp5789852p5790688.html Sent from the PostgreSQL - general mailin

Re: [GENERAL] Temporary table already exists

on stored_functions_v0.get_deck_types(bigint) line 12 at SQL statement STATEMENT: SELECT * FROM stored_functions_v0.get_deck_master_properties($1) ERROR: current transaction is aborted, commands ignored until end of transaction block ​Thanks in advance. Mephysto​ Il 05/feb/2014 17:21 &quo

Re: [GENERAL] Temporary table already exists

temporary table was atomic for every session (transaction). But I think that I'm not true. Are The two selects in the same session in my case? Why? Thanks in advance. Mephysto On 6 February 2014 04:40, Adrian Klaver-3 [via PostgreSQL] < ml-node+s1045698n5790784...@n5.nabble.com> wrote:

Re: [GENERAL] Temporary table already exists

I don't need local sorting, I only had to retrieve some objects from db belongs to user. A this point is it better unlogged tables or postgres object arrays? Il 06/feb/2014 09:35 "alexandros_e [via PostgreSQL]" < ml-node+s1045698n5790806...@n5.nabble.com> ha scritto: > @

[GENERAL] Streaming replication info

Hi there, I would to configure a multinode PostgreSQL system using streaming replication. In my mind, I would have a base configuration with a master node and more than one slaves in streaming replication. I have no difficult to imagine start situation, but my problems come when master fails: if m

[GENERAL] Custom types and JDBC

Hi, I would use custom types in several stored functions and I would my sotred function return these custom types. I would launch stored functions and retrieve results by JDBC interface: is it possible to map postgres custom types to java objects without resultset use? Thanks in advance. Meph -

[GENERAL] Custom types and JDBC

Hi, I would use custom types in several stored functions and I would my sotred function return these custom types. I would launch stored functions and retrieve results by JDBC interface: is it possible to map postgres custom types to java objects without resultset use? Thanks in advance. Meph --

Re: [GENERAL] Custom types and JDBC

This is the point! I would to know if an alternative of resultset exist to retrieve custom data types from postgres by jdbc. I explained me? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Custom-types-and-JDBC-tp4387382p4387475.html Sent from the PostgreSQL - general m

Re: [GENERAL] Custom types and JDBC

M no, my goal is for example: define a typeFoo (id as int, name as varchar) in postgres, define an object in java objFoo (id as int, name string), define a stored function in posgres return a typeFoo create ora replace function getFoo() returns typeFoo as $$ begin .. end; $$ I would to

Re: [GENERAL] Custom types as parameter in stored function

Ehmmm, sorry.. Correct syntax for select is: select myfunc((1, 'foo')::myType); -- View this message in context: http://postgresql.1045698.n5.nabble.com/Custom-types-as-parameter-in-stored-function-tp4527618p4527663.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -

[GENERAL] Custom types as parameter in stored function

;)::myType; In this manner, if I understand it, there is a positional assignment of attribute value: id = 1 and name = foo. My ask is is there a manner to assing value to attribute of custom type by name instead by position. Thanks in advance. Mephysto. -- View this message in context: http://

Re: [GENERAL] Custom types as parameter in stored function

Thank you Merlin. Now, Can I pass the select as an argument of my function? Or must I do in other manner? Sorry, but I am a novice. Best regards. Mephysto -- View this message in context: http://postgresql.1045698.n5.nabble.com/Custom-types-as-parameter-in-stored-function-tp4527618p4529531

[GENERAL] Hashing text in hexadecimal

Hello to everyone, I would need to hash some text and I would to produce an hexadecimal value as result. Is there a postgres function to achieve this goal? Thank you very much. Mephysto -- View this message in context: http://postgresql.1045698.n5.nabble.com/Hashing-text-in-hexadecimal

[GENERAL] Expanding psql variables

ELECT * FROM :my_schema.my_table; $BODY$ LANGUAGE sql; In this manner I receive a syntax error near: The question is: is there a manner to expand psql script variables inside dollar quoted string? Thanks in advance. Mephysto -- View this message in context: http://postgresql.1045698.n5.nabbl