PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX ...
0
votes
2answers
25 views
How to dump a part of a table from PostgreSQL?
I have a PostgreSQL database with a multi-Gb table (which contains a log of certain events). I need to pass the latest events to an analyst - let's say he only needs events from the last month.
How ...
0
votes
1answer
7 views
Regarding Reinstalling PostgreSQL
I was using PostgreSQL 8.4. I tried removing it through Synaptic Manager and then I tried to install 9.1, but I still version 8.4. I deleted all the files associated with postgresql. Now I am unable ...
3
votes
1answer
33 views
PostrgreSQL privileges granting
Given I am a root user X. I have users A and B.
How do I GRANT user A to enable him granting user B to execute a specific set of functions?
For example we have user A that owns database_1. User A ...
0
votes
1answer
25 views
Empty error on starting almost-default PostgreSQL
When trying to start PostgreSQL, I get this 'empty' error message:
root@mountain-lion:/home/ubuntu# service postgresql start
* Starting PostgreSQL 9.1 database server
* Error: could not exec ...
1
vote
2answers
25 views
backing up postgres on ec2
Ok, I'm quite new to this server administration stuff. I have set up an ec2 instance running my website. I'm running everything on a single machine - node.js & postgres. What is the best way to ...
2
votes
0answers
24 views
.\postgres looses “Log on as a service” after reboot; PostgreSQL service does not start
I've installed PostgreSQL 9.1 x64 on a Windows 7 Enterprise x64 system using the usual install method. The computer has a Novell Client for Windows, and a ZENworks Adaptive Agent, which I suppose ...
0
votes
1answer
17 views
ERROR: function make_standard_name(unknown) does not exist while installing OSM-nominatim API
I am installing nominatim on my own server using the guidence of http://wiki.openstreetmap.org/wiki/Nominatim/Installation...
But I am facing problem while adding country phrases / codes to my pgsql ...
0
votes
0answers
33 views
Unable to connect to new postgres install in Pangolin
Successfully installed postgresql-9.1 using apt-get on Ubuntu Precise Pangolin. When logged in to the postgres user(owner of the postgresql service), I checked the status with the results below:
...
1
vote
1answer
19 views
psql asks for password despite trust authentication
In /var/lib/pgsql/9.1/data/pg_hba.conf, I have the following:
# TYPE DATABASE USER ADDRESS METHOD
host all all 127.0.0.1/32 ...
0
votes
0answers
14 views
http 1.1/ 504 error after 30 seconds on apache for windows
i'm working on a windows server 2008 ee, that uses apache 2.2.15 to make a netbeans project work through glassfish 2.1, to save data ina postgres 8.4 database. Such database saves data to a table that ...
0
votes
0answers
20 views
PostgreSQL 1 master, multiple slave replication over slow links
I have a current use case in which remote computers query a central PostgreSQL database over a internet connection (read-only). We would like to implement a "stand-alone" system for these terminals so ...
7
votes
1answer
76 views
How to use a custom status command for a service in puppet?
I am using debian squeeze with PostgreSQL 9.1 from backports. Puppet has version 2.7.14.
Unfortunatly the init script returns the wrong exit code for status. Therefore I wrote a custom status command ...
0
votes
0answers
18 views
How to setup the slave database server in a PostgreSQL database cluster?
I want to setup a PostgreSQL Cluster in an Active/Hot-Standby setup. If the active one fails, the database migrates to the Hot-Standby using Pacemaker and DRBD. No problem until this point.
I also ...
1
vote
4answers
114 views
As a small business, how can I host a static 500GB database in the most cost-effective way possible?
My company is building a database from a large publicly available data set. When we complete it, we will have something like 500GB of data, but the data will never grow beyond that. It takes ...
scalability
3
votes
2answers
37 views
Lock out PostgreSQL users for maintenance
In PostgreSQL 8.4.9 with pgbouncer 1.3.4 in pool_mode = session
(but some users connect to the database directly) - when I login as "super user" with
psql -U postgres -W postgres
What is the ...
-2
votes
1answer
40 views
Many Postgresql process. how to handle them?
I'm trying to fix an already install openNMS system on ubuntu. Currently I'm facing issue with postgresql. I stop server using this commnad:
service postgresql -$PGVERSION stop
after that when i ...
-2
votes
0answers
22 views
Configure Lampp with postgresql [closed]
I need to run lampp using postgresql instead mysql (i've already lampp and postgresql on my pc). How can i do? thanks
0
votes
1answer
21 views
If I have Postgres streaming replication on, do I still need to archive my WAL files?
I have set up two servers running Postgres 9.1, with one configured as a hot standby for the other using streaming replication. Given that, is there any reason for me to be archiving my WAL files?
...
1
vote
2answers
55 views
PG pool failover leads to two independent masters with network failure
I've got two servers set up with PG Pool to create a HA setup for a webapp.
PGPool and postgres run on both servers, using streaming replication from server 1 to server 2. The webapp on each machine ...
0
votes
1answer
105 views
PostgreSQL 9.1 on Ubuntu Lucid fails to start - how to debug?
I'm using Vagrant with Chef Solo to setup a Lucid 64 box.
I'm using a Chef recipe to install PostgreSQL 9.1 from Martin Pitt's backports.
The install goes ok until the point where the database is ...
0
votes
1answer
24 views
pg_dumpall, how do you specify a different cluster
running pg_dumpall makes a backup of the cluster "main", but I have another cluster "custom". How do I make pg_dumpall produce a backup of "custom"?
0
votes
0answers
21 views
pg_restore no connection error
Getting the following error when I run pg_restore to make a copy of a database:
pg_restore: [archiver (db)] could not execute query: no connection to the server
I get the error multiple times ...
0
votes
2answers
46 views
Postgresql won't start, “Socket conflict”
I have a problem starting Postgresql on Gentoo.
$ /etc/init.d/postgresql-9.1 start
* Socket conflict.
* A server is already listening on:
* /var/run/postgresql/.s.PGSQL.5432
* HINT: Change ...
-1
votes
0answers
23 views
Password problems with postgreSQL [closed]
I've accitently managed to install postgresql 8.4 on my mac. I have no Idea on how to use this stuff and want to get it uninstalled. I tried a tutorial on the web about manuall uninstallation, but ...
0
votes
4answers
693 views
Postgres used in Ubuntu 12.04
I am trying to get django running on an ubuntu 12.04 release using postgres (clean install). To get it running it used to be that you would have to edit the /etc/postgresql/9.1/main/pg_hba.conf file. ...
-1
votes
1answer
44 views
Cannot access psql after installing postgres
I installed postgresql via homebrew on my 10.7.3. The install seemed successful and I was able to start up the server. However when I try to access psql I get the following error:
psql: FATAL: role ...
-1
votes
2answers
107 views
Postgres cannot start on lion due to missing server configuration file
I am trying to setup pg on a relatively clean lion install and it's not being successful.
First I successfully installed homebrew, and installed postgresql without any errors.
Then I tried to run a ...
1
vote
1answer
35 views
Scripting postgres synchronization--is this secure?
I have written a script to synchronize (recreating from scratch) a production database with a development database, and I wanted insight into potential security flaws/issues, the script is posted ...
0
votes
0answers
10 views
How do I get the DSV definition if the DSV wizard fails?
I'm trying to build an Integration Services package with BIDS(2008R2) with a non-SQL server datasource. The Data Source View Wizard is producing an invalid syntax in the DSV due to an issue with the ...
3
votes
3answers
67 views
Setting up Postgres: Can't connect remotely to Postgres server
I am having a problem getting postgres to accept connections from my other server. Here's my setup:
APP06 (10.55.129.31): Server running Postgres
APP05 (10.55.129.30): Server trying to connect to ...
0
votes
0answers
24 views
How to run PostgreSQL Query in single JSP file? [closed]
I want to run PostgreSQL Query in the JSP file !
Can everybody give me simple example?!
Regards
0
votes
1answer
31 views
Are there any JSP File for manage PostgreSQL database?
1.
I need jsp file to manage PostgreSQL database?!
Anyone know JSP file for manage PostgreSQL database?!
2.
How I can connect to remote PostgreSQL Server with Webmin?!
2
votes
1answer
54 views
syslog writing to general instead of specific file
I'm running Ubuntu and Postgresql 9.
I've enabled postgresql to log to syslog, and added the following directive to the config file:
syslog_facility = 'local0'".
I've tried to configure syslog ...
-2
votes
1answer
24 views
how to configure server odbc for postgresql windows
i want to put in the server machine the database postgresql
and i have also to define the client
can you tell me how i'm going to configure odbc data source to connect
os:windows
thanks for your ...
0
votes
1answer
28 views
pgpoolAdmin keeps going straight back to it's login page
I'm trying to run pgpoolAdmin through nginx - it seems to be working properly, at least initially.
I've gone through the initial set-up, which works fine, but now after logging in every link takes me ...
1
vote
1answer
29 views
Using Postgres on Volusion site
Okay, I apologize if this is so basic that I should know the answer, but I'm not sure where else to go for the solution.
I would like to start a small store site using Volusion. I would like some ...
0
votes
1answer
33 views
PostgreSQl - creatdb with shell script
I have a small shell script thats gets triggerd by another script via ssh.
#!/bin/bash
if [ -z $1 ]
then
echo "Missing DB Name!"
exit 1
else
PROJECT=$1
fi
createdb -U postgres -T ...
2
votes
3answers
55 views
MySQL to PostgreSQL replication
Is there way to replicate in near-realtime MySQL changes to equal PostgreSQL database?
2
votes
2answers
55 views
postgresql log queries single database
I'm using PostgreSQL (8.3) with multiple databases... I'm wondering if there is some way to log the queries made only in one of the databases (not all of them).
Or to have one logfile per ...
2
votes
2answers
76 views
How to scale out OpenStreetMap data efficiently
For over a year now, I'm running an in-house PostGIS server filled with OSM data, used for both Mapnik-based tile generation and Nominatim-based geocoding, updated with day replicates. This works ...
0
votes
1answer
62 views
Cron job failing to backing up a Postgres database
I'm unsure what's going on here:
I've got a backup script which runs fine under root. It produces a >300kb database dump in the proper directory.
When running it as a cron job with exactly the same ...
-1
votes
1answer
55 views
Is PostgreSQL database optimised for any particular CPU?
This question may sound strange, but some CPU have instruction sets for virtualisation technologies, while some non-related software can use those sets, or even GPU to improve their performance.
So, ...
0
votes
1answer
44 views
Advanced PostgreSQL user management
For the users in our institute, we want to provide a quick and simple way to use PostgreSQL databases. Currently, we are already able to authenticate all users through LDAP (PAM). This works rather ...
0
votes
0answers
32 views
Amavisd-new(2.6.4-3) failing to do “lookup_sql_dsn” when large number of emails are need to be accessed
Amavis is failing to do sql lookup when large number of emails are sent to amavis. Its throwing out error after scanning 40 to 50 email. It shows error like.
(!!)TROUBLE in process_request: sql ...
0
votes
0answers
96 views
Error installing PostgreSQL on WIndows Server 2008 Standard x64
When I install PostgreSQL, I get the following error before the installation rolls back:
PostgreSQL 8.2
---------------
Failed to run initdb: -1073741502!
Please see the logfile in 'C:\Program FIles
...
0
votes
1answer
150 views
Unable to connect to Postgres on Vagrant Box - Connection refused
First off, I'm new to Vagrant and Postgres.
I created my Vagrant instance using http://files.vagrantup.com/lucid32.box with out any trouble. I am able to run vagrant up and vagrant ssh with out ...
0
votes
0answers
31 views
Error during PostgreSQL start
I try to start PostgreSQL but have following error:
* Starting PostgreSQL 8.4 database server
* Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl /usr/lib/postgresql/8.4/bin/pg_ctl start ...
2
votes
3answers
269 views
How to set shmall, shmmax, shmni, etc … in general and for postgresql
I've used the documentation from PostgreSQL to set it for example this config:
>>> cat /proc/meminfo
MemTotal: 16345480 kB
MemFree: 1770128 kB
Buffers: 382184 kB
...
0
votes
0answers
27 views
Ubuntu/PSQL unable to show chinese characters?
I have Chinese characters in my PSQL DB and it is unable to show Chinese characters (Not from the terminal, applications work fine). Similarly I can't type Chinese characters in the terminal shell... ...
0
votes
2answers
186 views
Creating the postgres user on OSX LION
Currently I do not have a postgres user.
~$ sudo su - postgres
Password:
su: unknown login: postgres
So, I was following these instructions as a quick-start to postgres ...
