Re: [GENERAL] strange connection problem.

On 10/23/2015 08:23 AM, Day, David wrote: One app is connecting through libpqxx, the other 2, glassfish and ejabber chat agent, I am not certain. It is only on this one machine where I am having a connection issue with any of these apps. I can connect via the identical roles that these

Re: [GENERAL] strange connection problem.

I figured this out and it is not a Postgres issue. There was a area of initialization overlooked by the installer on a fresh install of a development system.. I had to add a little extra debug to see that one key job not only was not getting attached to the database, it was not even trying.

Re: [GENERAL] A question about PL/pgSQL DECLAREd variable behavior

On 10/22/15 8:52 PM, Dane Foster wrote: It just occurred to me that another option, for my specific example, would be to record/cache FOUND instead of testing the RECORD variable for its NULLness. Unless of course assigning FOUND to a variable is a pass-by-reference assignment, which in the

Re: [GENERAL] A question about PL/pgSQL DECLAREd variable behavior

2015-10-23 18:05 GMT+02:00 Jim Nasby : > On 10/22/15 8:52 PM, Dane Foster wrote: > >> It just occurred to me that another option, for my specific example, >> would be to record/cache FOUND instead of testing the RECORD variable >> for its NULLness. Unless of course

Re: [GENERAL] strange connection problem.

"Day, David" writes: > I have a development site ( FreeBSD 10.1 and Postgres 9.3 ) where I can > connect to the database via psql or pgadminIII both locally and remotely. > However, all of the local apps ( 3 different ones ) that would connect to it > are failing to connect.

Re: [GENERAL] clone_schema function

The script is generating foreign keys which reference tables in the source schema. I had to change 219SELECT 'ALTER TABLE ' || quote_ident(dest_schema) || '.' || quote_ident(rn.relname) 220 || ' ADD CONSTRAINT ' || quote_ident(ct.conname) || ' ' ||

Fwd: [GENERAL] trouble downloading postgres 9.4 for RHEL 6.x

Hello all, I got past the yum install, ran initdb but running into errors when starting service. Do you have to login as user postgres to start the service? THANKS I am on RHEL 6.5 and don't know the postgres user password. service postgresql9.4 start postgresql9.4: unrecognized service

Re: Fwd: [GENERAL] trouble downloading postgres 9.4 for RHEL 6.x

On 10/23/2015 11:45 AM, anj patnaik wrote: Hello all, I got past the yum install, ran initdb but running into errors when starting service. Do you have to login as user postgres to start the service? THANKS I am on RHEL 6.5 and don't know the postgres user password. Off-list message

Re: [GENERAL] strange connection problem.

On Fri, Oct 23, 2015 at 10:29 AM, Day, David wrote: > I have a development site ( FreeBSD 10.1 and Postgres 9.3 ) where I can > connect to the database via psql or pgadminIII both locally and remotely. > > However, all of the local apps ( 3 different ones ) that would connect

Re: [GENERAL] strange connection problem.

On 10/23/2015 07:29 AM, Day, David wrote: I have a development site ( FreeBSD 10.1 and Postgres 9.3 ) where I can connect to the database via psql or pgadminIII both locally and remotely. However, all of the local apps ( 3 different ones ) that would connect to it are failing to connect. I

Re: [GENERAL] clone_schema function

Good catch. Thank you very much! On Fri, Oct 23, 2015 at 10:50 AM, Predrag Maric wrote: > The script is generating foreign keys which reference tables in the source > schema. > I had to change > > 219SELECT 'ALTER TABLE ' || quote_ident(dest_schema) || '.' || >

Re: [GENERAL] strange connection problem.

One app is connecting through libpqxx, the other 2, glassfish and ejabber chat agent, I am not certain. It is only on this one machine where I am having a connection issue with any of these apps. I can connect via the identical roles that these apps would be using via the psql command line

[GENERAL] strange connection problem.

I have a development site ( FreeBSD 10.1 and Postgres 9.3 ) where I can connect to the database via psql or pgadminIII both locally and remotely. However, all of the local apps ( 3 different ones ) that would connect to it are failing to connect. I see no error events in the

Re: [GENERAL] strange connection problem.

On 2015-10-23 08:29, Day, David wrote: > I have a development site ( FreeBSD 10.1 and Postgres 9.3 ) where I can > connect to the database via psql or pgadminIII both locally and remotely. > > However, all of the local apps ( 3 different ones ) that would connect to it > are failing to

Re: [GENERAL] question

On 10/23/2015 03:22 PM, anj patnaik wrote: Quick update on the above: 1) I got past the password prompt by changing the pg_hba.conf on target machine to trust. 2) I am still running this command to restore on remote machine and want feedback as it appears to NOT create the desired table: