Questions specific to version 9.0 of the widely-used PostgreSQL relational database system
1
vote
2answers
1k views
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 recently had major permission problems using Lion Server where permissions would change on folders at will. During this time I had started getting the following error when trying to do a rake ...
0
votes
2answers
45 views
Error in archive_command in window 7
I have done these steps:
Opened postgresql.conf
Set these parameters:
wal_level = archive
archive_mode =on
archive_command = ''copy %p \\192.168.1.10\Archive\wals\%f''
Where 192.168.1.10 is my PC ...
2
votes
1answer
350 views
PostgreSQL Query Cache - closing connection unexpectedly
<?php
$c = pg_connect( $connectionString, PGSQL_CONNECT_FORCE_NEW );
$queries = array (
"SELECT COUNT(*) AS data FROM articles",
"SELECT * FROM posts WHERE visible = TRUE",
...
1
vote
1answer
156 views
Cannot Fetch Postgres 9.0 Package For Install in Ubuntu/CloudFoundry
I'm trying to install CloudFoundry (VCAP) on an ubuntu 10.04 server instance.
Following these directions: http://blog.modeltwozero.com/2011/05/running-cloud-foundry-on-amazon-ec2-or.html
...
0
votes
1answer
85 views
How to pg_restore a dump file generated from heroku to my local postgres 8 database?
I downloaded my latest backup file from heroku to my local drive using this command:
$ heroku pgbackups:capture
$ curl -o latest.dump `heroku pgbackups:url`
Then I tried to restore with:
$ ...
heroku
0
votes
1answer
30 views
pdf = rs.getBytes(“pdf”); it not working in windows os .what is the alternate for read binary data from postgres bytea field
this code when i write in the linux it will work fine but in windows it is porduceing the double size of actual data in windows OS.will any one suggest me write solution.
0
votes
1answer
107 views
PostgreSQL / Dumping 9.0 and reimporting in 9.2
When dumping my database 9.0 with the aim to re import it in 9.2, I have issues with schemas.
For example, my table bar in schema foo is exported like this :
SET search_path = foo, pg_catalog;
...
...
0
votes
1answer
192 views
Error with schema on tomcat
I have a tomcat 7 server, and a postgreSQL 9.0 DB. I use it to setup a development environment for geonetwork metadata editor. Everything is set up according to the geonetwork web-site tutorial. I ...
0
votes
1answer
125 views
how to generate fixtures for postgresql schema and tables using django
I am using django and postgresql db to develop my project, the db has 3 schemas. And I am writing raw quires using connection string to fetch data and insert data into tables.
Example:
from ...
0
votes
1answer
75 views
Within Table Subquery of Identical Combinations
I would like to select groups that have the exact same attributes from a table. For example, my table is like the following
facs_run_id | fcj_id
1 | 17
1 | 4
1 ...
2
votes
0answers
213 views
Postgres 9.0 Binary Replication - Can Archive Mode be turned on for Standby Server?
I am setting Postgres 9.0 binary replication & Archive backup.
For Archiving on Master, I have these options:
a) Copy archive to it's local backup location
b) Copy to a share network location ...
0
votes
0answers
10 views
mirroring PostgreSQL roles from another server
Suppose I want to take all the roles from a production server and mirror them on a dev server. I cannot just dump the roles from production and then apply the dumped SQL to the dev server, because if ...
0
votes
0answers
10 views
Error Installing PostGreSQL 9.0.X
get this while installing Windows version of 9.0.12
psql: could not connect to server: Connection refused (0x0000274D/10061)
Failed to install the 'adminpack' module in the 'postgres' database
...
0
votes
0answers
125 views
postgres streaming replication stale nfs file handle
I followed the commands as shown in this postgres page http://wiki.postgresql.org/wiki/Streaming_Replication.
However the first time when i got to the point of pg_stop_backup() it failed. It had the ...
