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 messages/postgres
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 connect.
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 to
> it are failin
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 s
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) || '.' ||
> quote_ident(rn.relname)
> 220
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 o
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 actua
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 assigning FOUND to a variable is
"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.
Are those apps t
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 apps
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.
Afte
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) || ' ' || pg_get_constraintdef
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
-bash-
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 indicat
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:
xzcat
15 matches
Mail list logo
