current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0

Tagged Questions

0
votes
0answers
26 views

RoR: 'NameError Exception: uninitialized constant Address' when trying to access recently added data from a populated postgresql table

I have created a Ruby script that inserts data into a PostgreSQL database. The db exists and so do the tables. I have an Address model and a Company model in my app and those two are connected ...
0
votes
1answer
19 views

Reuse persistent dblink connection

We have a function that is quite often triggered and make a query to a remote db. If I am not wrong the connection persist just in the scope of the current call/session of the function. Is it possible ...
1
vote
1answer
27 views

Unable to connect to PostgreSQL 9.3

Recently, I have installed PostgreSQL 9.3 on my windows 7 64 bit PC but today I have formatted my PC. Now again I tried to install PostgreSQL 9.3 but after installation when I tried to connect it ...
1
vote
0answers
19 views

ActiveRecord Postgresql Clear Connections Doesn't seem to actually clear them all the time

We're attempting a new mechanism for clearing out our db in between test runs, as we're having a hell of a time on Capybara tests with the shared connection strategy. Our basic idea with Postgresql ...
0
votes
0answers
30 views

How to Setup Java Database Application Connection to both Master & Slave Servers

So I have setup replication between two databases (master & slave) and the replication works correctly. Now my question is, how do I setup my application's database connection so that it connects ...
1
vote
2answers
56 views

What are the options for saving data locally upon a failed Postgres SQL connection

I'm building a C# application that uses a PostgresSQL database (version 9.3) in the cloud for storage. While my office connection is fiber and extremely stable to the db provider that might not be the ...
-1
votes
1answer
38 views

What is the proper syntax in Postgres for addressing tables?

In sql-server, one can connect to the master db and write a statement in the below syntax to query any table: SELECT * FROM [database].[dbo].[table] I've ran some google searches for "postgres full ...
0
votes
1answer
429 views

Talend failing connection to PostgreSQL

I am currently creating an ETL job in talend which is connecting to a PostgreSQL database and I ran into a connection error. I have set up a db connection in my talend repository with all the ...
-1
votes
2answers
88 views

Postgre SQL Schema Bind of Connection

we have a presentation of a java gui handling a postgresql database. On the presentation-server we have some schemas and one is reserved for our group. My problem now is in binding a Schema to the ...
-3
votes
1answer
1k views

How to Connect PostgreSQL with VB.NET Application

I want to connect my VB.NET windows application with PostgreSQL 9.3 Beibg a beginner i am unable to do it through ODBC, and Npgsql Dim mDAKap As New Odbc.OdbcDataAdapter Dim mCon As New ...
0
votes
3answers
55 views

How to set up postgresql from php (beginner)?

When I try to execute pg_connect() in PHP, it does not work and I have come to the realization that my php settings are such that it cannot understand this function, and the php error message reads: ...
0
votes
0answers
213 views

How to connect to Postgresql database via PHP (Heroku)

In my project, I am trying to use PostgreSQL to store user information like password, ID etc. I began using Heroku last week and I am having some trouble connecting to the database in PHP. My code ...
2
votes
3answers
1k views

PostgreSQL: Warning: Console code page (437) differs from Windows code page (1252)

Using PostgreSQL when I connect to a db using \c testdb inside PostgreSQL Database SQL Prompt. I successfully connect to the db but getting the following warning: postgres-# \c testdb WARNING: ...
2
votes
1answer
169 views

Python: decryption failed or bad record mac when calling from Thread

I'm getting a "decryption failed or bad record mac" error in this code-fragment: conn = psycopg2.connect(...) cursor = conn.cursor() cursor.execute("SELECT id, ip FROM schema.table;") rows = ...
2
votes
1answer
168 views

Are “best practices” regarding connection handle re-use and database user design mutually exclusive?

SO says this may be subjective. I'm hoping not--I just can't seem to understand how this works in practice, and it seems like a specific enough technical question with I hope a definitive answer. ...
0
votes
2answers
131 views

Safe design for SET SESSION AUTHORIZATION multi-user mod-perl2 connection caching

I have a mod_perl2.0.4 / Apache2.2 web app running on CentOS 6.4 with PostgreSQL 9.0. Until recently, I had this setup: Apache::DBI and DBI->connect_cached for all connections, which was starting to ...
1
vote
0answers
89 views

PostgreSQL + Lazarus Pascal - failed connection during use

I've built a program using Pascal + PG on a single PC running Ubuntu 12.04. It's been working fine for about a month now, until this morning. So I'm not sure if it's an auto-update of the OS that did ...
0
votes
1answer
61 views

Postgresql server refuses connection despite authorizing it

I'm connecting to a Postgresql server (version 8.4) with a Spring application. My connection parameters are: <Environment name="/db/driver_class" value="org.postgresql.Driver" ...
1
vote
1answer
144 views

Questions about Rails-Postgres Database connections

We have recently been having issues with postgres running out of connection slots, and after a lot of debugging and shrugging of shoulders we have pretty much tracked it down to the fact that we ...
0
votes
1answer
35 views

I can connect on Postgresql Database but queries give no results

I've a Postgresql database on my server and I would like to use it for a simple web-app on localhost. I've set the Database to allow my connections ecc.. In fact, my web-app can connect to the DB... ...
0
votes
1answer
41 views

Create an array of connections to the database

Is there a way to create an array of connections in c++. I want to create something like this. connection arr[5]; for(int i=0;i<5;i++) { connection c("dbname=test user=postgres password=abc123 ...
0
votes
2answers
68 views

java with postgresql mistake with statement

I have tried to getting result from db about has done query,db always get me "false" even when that has trued. oldPassword = DBConfig.MD5(oldPassword); //thase are me own classes newPassword = ...
0
votes
3answers
913 views

cannot connect to Postgres (pg) database from my Ruby Script using gem “pg”(This is not rails, just pure ruby)

I downloaded the postgres.app for my Mac OSX machine. I have a rails app that has connected and used the postgres DB that came with the postgres app. Now I am writing a pure Ruby test script (Not ...
0
votes
2answers
142 views

running rails on guest linux virtualbox: a database.yml issue

a) I'm a ruby in rails beginner developer, and I use windows 7 machine as developement environment... b) With VirtualBox I just installed, inside the Windows 7 "host", a Linux ubuntu sever "guest", ...
1
vote
1answer
134 views

Does the PG Ruby Gem use pgpass when setting up PostgreSQL connection?

I'm writing a Ruby script that uses the PG gem to set up a database connection and send files. I'm structuring it to take variables for the hostname, username, database name, and port. In a Shell ...
1
vote
1answer
251 views

“no pg_hba.conf entry for host” but “LOG: connection authorized”

I have a wierd problem. I have a service running using PostgreSQL 8.3. On parallel platform I have installed PostgreSQL 9.1 and try to connect to it using my working php script. Got an answer: ...
2
votes
3answers
287 views

Cannot connect to two postgres databases in rails 3.2.

I've tried a few methods found on stack overflow for connecting to two database in rails two however non of them are working. Here's what I've got at the moment: In the database.yml there's two ...
0
votes
2answers
989 views

Simple C++ program using pqxx (postgres)

I'm trying a very basic C++ program using Code::Blocks. I'm on Ubuntu 12.04 and installed pqxx from the software manager. Here's the code. #include <pqxx/pqxx> #include <iostream> using ...
0
votes
2answers
134 views

Is there a complete example/tutorial (or at least an alternative to wxODBC) for CodeBlocks + Postgres

I am just starting to program Code::Blocks with Postgres. I haven't tried any other DB platform either with it. So far I've found that DB connections and coding can be done using wxODBC. wxWidgets is ...
2
votes
2answers
471 views

web2py webserver - Best way to keep connection to external SQL server?

I have a simple web2py server that we use to visualize data from our PostgreSQL Server. The following functions are all part of the global models in web2py. The current solution to fetch data is very ...
1
vote
1answer
234 views

At what point should Node be creating the database connection?

I have a Node.js application using PostgreSQL via node-postgres. I have started receiving the error "sorry, too many clients already", and this has made me wonder if I am creating too many client ...
1
vote
1answer
4k views

How to configure Postgresql with rails project?

I am very new to ruby. I am trying to run BBYIDX and followed How to install BBYIDX on Windows? When I try rake db:migrate it reproduces error as (in /home/virinchy/BBYIDX-2/BBYIDX-master) ...
0
votes
1answer
123 views

PostgreSQL installation as a user on Cygwin, database server setup

I'm trying to install PostgreSQL on Cygwin as a user and i'm getting stuck on the part where I have to create a database server, after i execute the pg_ctl command, it just prints "server starting" ...
1
vote
1answer
112 views

PostgreSQL installation as a user on Cygwin

I'm trying to install PostgreSQL on Cygwin as a user following the instructions given in the cygwin package installation: cygrunsrv -S cygserver initdb -D /usr/share/postgresql/data pg_ctl start -D ...
1
vote
1answer
1k views

installing PostgreSQL on Cygwin as a service

I'm a novice trying to install Postgresql on Cygwin as a service. I have been following the steps listed in this URL: http://www.smartpixie.com/wiki/Tech/CygwinPostgreSQL.twiki.html Everything was ...
3
votes
1answer
2k views

pgAdmin III Guru Hint - Server Not Listening [closed]

When I connect to default localhost 5432, I get a blank "Guru hint - Server not listening message" Normally, it should show some messages but I get a blank one! Can somebody please tell me what's ...
0
votes
1answer
144 views

Connection with Asynchtask to PostgreSQL crashes

Got a Problem with the Connection to my PostgreSQL Database with ASynchTask. When trying it with the correct database setting (pg_host, pg_user, etc) it works. The problem is when trying it with ...
4
votes
2answers
5k views

psql: FATAL: role “postgres” does not exist (with -h localhost option)

I have Postgres installed in my local machine. When I execute psql -U postgres -d buzzsumo it correctly asks for my password to the user postgres. However, when I run psql -U postgres -d ...
0
votes
1answer
340 views

Cannot connect to postgresql as postgres user

I am using mac OS X 10.5.8. I installed PostgreSQL 9.1 (using a mac dmg driver) in order to build a database with python (using sqlalchemy and psycopg2). When I first tried to connect to PostgreSQL ...
0
votes
1answer
152 views

Why can't my Django application reach my Postgres server?

Both servers are VirtualBox servers on my host machine, and I'm able to network between them just fine (ssh from one to the other, etc.), other than this issue (which I don't know enough about to rule ...
0
votes
1answer
200 views

Why can't I use postgres even when it is running? [duplicate]

Possible Duplicate: PostgreSQL Permission denied Error on Unix domain socket “/var/pgsql_socket/.s.PGSQL.5432” - Lion Server 10.7.3 or Lion Server 10.7.4 I'm using postgres as my backend ...
12
votes
2answers
16k views

Is there a timeout for idle PostgreSQL connections?

1 S postgres 5038 876 0 80 0 - 11962 sk_wai 09:57 ? 00:00:00 postgres: postgres my_app ::1(45035) idle 1 ...
2
votes
3answers
263 views

Find out which schema based on table values

My database is separated into schemas based on clients (i.e.: each client has their own schema, with same data structure). I also happen to have an external action that does not know which schema it ...
0
votes
1answer
1k views

fe_sendauth: error sending password authentication

I'm now learning Django and am following the Django book step by step. When I proceeded to chapter 5 to connect my Django project to my database, I can't get it to connect. I get the error: FATAL: ...
2
votes
2answers
7k views

Visual Studio Entity Framework connect to Postgres database

I want to connect to a Postgres database using EntityFramework. Is that possible? I select: Add>>New Item>>ADO.Net Entity Data model>>Generate from database>>New connection But I'm stuck ...
1
vote
3answers
2k views

Conflicting versions of postgres database and server

I installed postgres on Mac OS X 10.6.x. When I ran for postgres database version: psql --versionpsql (PostgreSQL) 9.1.1 contains support for command-line editing When I checked for the version ...
2
votes
1answer
2k views

Glassfish, PostgreSQL and closed connections

We have an application using MySQL on Glassfish using JPA (Hibernate) which is working fine. We then switched to PostgreSQL and almost everything is working fine. The only problem that we have, is ...
2
votes
1answer
1k views

Connecting to my RoR's Heroku Postgres database?

I am running a Ruby on Rails app on Heroku. It uses a Postgres database. I want to connect to the database from some scripts I am writing and running locally. Using ENV['DATABASE_URL'] I found my ...
1
vote
2answers
571 views

How to easily and safely connect to postgres or mysql remotely?

I would like to know how can you connect to postgresql in these conditions: allow you to access them from any location (do IP filtering) safe connection (no risk on having your password captured) ...
2
votes
1answer
735 views

Programmatic connection validity check for a Postgresql database in Java

I have a stand-alone java application that makes some database read/write business on a postgresql database. I used the isValid function available on a java.sql.Connection object in order to ...

1 2