stored procedure call is not working with "select procedure()" option

Hi , I have a stored procedure name "procedure()". Which I am calling by -- Session sess = (Session)entityManager.getDelegate(); //entityManager is javax.persistent.EntityManager[ Properly Initialise] sess.createSQLQuery("select procedure()"); procedure is containing some

Re: Error when compiling postgresql 9.6.7 with Visual Studio 15.5.6

On Mon, Feb 19, 2018 at 04:17:18PM -0500, Tom Lane wrote: > Well, as far as I'm concerned the patch that was proposed there is > far too fragile to be acceptable. We need to find out what the > Microsoft-approved way of getting the information is. Assuming that > we know the contents of

Re: pgBackRest backup from standby

On Mon, Feb 19, 2018 at 2:53 PM, David Steele wrote: > > Also, relocating the log directory is easy using the log_directory > setting, so that's what I recommend if it's an issue. Some users do > want to backup their logs. > > That's probably a lot better idea than

Re: Empty ./share/timezone/UTC and failure to set UTC as timezone

Hi Tom, thanks for quick response. I have to apologize to you, PG from source is fine. Sorry for wasting your time. It only happens that after I put it into archive (tar czf postgresql-9.6.7-linux-x64-binaries.tar.gz pgsql) and extract it, that it is empty and it looks like it is a bug in java

Re: pgBackRest backup from standby

On 2/19/18 2:05 PM, Don Seiler wrote: > On Mon, Feb 19, 2018 at 12:39 PM, David Steele > wrote: > > > I read "open it for testing (or backups in this case)" as letting > recovery complete and promoting the cluster to a master before

Empty ./share/timezone/UTC and failure to set UTC as timezone

Hello, we are using "embedded" PostgreSQL for integration tests (see https://github.com/yandex-qatools/postgresql-embedded) and we have noticed that our (java) clients fail to connect when their timezone is UTC, with PG server giving following error message: invalid value for parameter

Error when compiling postgresql 9.6.7 with Visual Studio 15.5.6

Hello everyone, When trying to compile postgresql 9.6.7 with Visual Studio 15.5.6, i am getting errors at these following line : "C:\Users\nameless\Documents\Works\Compiling\pgwininstall\builddir\postgresql\postgresql-9.6.7\pgsql.sln" (default targe t) (1) ->

Re: pgBackRest backup from standby

On 2/19/18 10:32 AM, Don Seiler wrote: > On Mon, Feb 19, 2018 at 9:21 AM, David Steele > wrote: > > > Yes, they are typically very small.  The general exception to this rule > is if logs are stored in pg_log.  I recommend storing logs

Re: pgBackRest backup from standby

Hi Don, On 2/19/18 10:01 AM, Don Seiler wrote: > On Mon, Feb 19, 2018 at 8:53 AM, David Steele > wrote: > > Anything *not* in global (except pg_control), base, pg_tblspc, > pg_xact/pg_clog, and pg_multixact are copied from the primary. >

Re: pgBackRest backup from standby

Hi Don, On 2/19/18 9:25 AM, Don Seiler wrote: > On Mon, Feb 19, 2018 at 8:18 AM, David Steele > wrote: > > It copies files that are not replicated from the primary so that a > primary-style backup is created. Anything that is replicated

Re: pgBackRest backup from standby

On Mon, Feb 19, 2018 at 8:18 AM, David Steele wrote: > It copies files that are not replicated from the primary so that a > primary-style backup is created. Anything that is replicated (which is > by far the bulk of the data) is copied from the standby. > OK so all data

Re: pgBackRest backup from standby

Hi Don, On 2/18/18 7:34 PM, Don Seiler wrote: > > Looking to use pgBackRest to take a backup from a hot standby. I'm > reading that pgBackRest still needs to connect to the primary and copy > some files. My questions are: > > 1. What files does it need to copy? Config files? WAL files? It

Re: shared_buffers 8GB maximum

When we did calculation of some analytic tasks, then increasing shared_buffers had negative impact on speed. Probably hit ration was too low after change, but the maintenance of shared buffers (searching free blocks) was slower. What was the size of shared buffers when slowdown happened

Re: shared_buffers 8GB maximum

Yes.  I don't know the exact reason, but reading a buffer from OS cache is quite a bit more expensive than just pinning a buffer already in the buffer_pool, about 5 times more expensive the last time I tested it, which was before Meltdown.  (And just pinning a buffer which is already in the

Re: Connection loosing at some places - caused by firewall

Hello! 2018-02-13 21:21 GMT+01:00 George Neuner : > On Tue, 14 Nov 2017 12:09:31 +0100, Durumdara > wrote: > > > >*I disabled my firewall at home - the [keepalive] problem vanished!!!* > > What firewall are you using? Windows own firewall doesn't

Re: Join query

hmidi slim wrote: > I have two tables: establishment which contains these columns: id, name, > longitude, latitude, geom (Geometric column) > Product contains: id, name, establishment_id > First of all I want to select the establishment within a radius. > I run this query: > select e.name,

Re: Deadlock with 2 processes waiting on transactionids and locking unrelated tables

My guess is that the transaction doing: update "planscheduleitem" set "planschedule"=$1 where "psi"=$2 updates ticket before reaching that point And update ticket set unread = true where ticketid = $1 updates planscheduleitem before that Does it make sense to you? Btw, do the transactions

Re: Deadlock with 2 processes waiting on transactionids and locking unrelated tables

Thanks for your response > Does any of the two tables have triggers? Yes the ticket table has a trigger that inserts changes into a ticketstatuslog table when the ticket.status column changes and on insert. ticket_status_insert_trigger AFTER INSERT ON ticket FOR EACH ROW EXECUTE PROCEDURE