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 ...
1
vote
1answer
16 views
control which version of PostgreSQL starts
I have three versions of Postgres (8.4, 9.0, 9.1) running on my Ubuntu box. Each version is configured to listen on a different port. When I reboot the machine, only the 9.0 version starts ...
1
vote
1answer
18 views
How to install PostgreSQL to run under a different system user than “postgres”?
I'm installing PostgreSQL on RedHat Linux using rpm installers and I'm trying to get the application to be owned and run by a system user other than "postgres", for example "dbuser5". It seems I ...
0
votes
1answer
17 views
call multiple Sql files in a single SQL file in Postgres
How do call multiple sql files in a single sql file, in postgres
For example I have aaa.sql, bbb.sql, ccc.sql.
I want to execute this 3 files from xxx.sql.
Can anyone suggest me how to do this.
0
votes
1answer
15 views
libapache2-mod-auth-pgsql and ssl-cert equivalent in CentOS
I switched this a time ago from Ubuntu to CentOS. Now, I faced this problem:
Trying to install a software that I installed before in Ubuntu, I stopped at the point where I need to install the above ...
0
votes
2answers
40 views
CentOS Postgres, Backup/Restore
We recently inherited a company and their CentOS server with a Postgres running their CSR db. They have a backup system in place which we know nothing about.
It creates backups of the Postgres DB in ...
-2
votes
1answer
69 views
Postgres function to loop GRANT statements
I have a number of GRANTs I need to make in a Postgres databas -- Is it possible to put statements like
GRANT SELECT ON TABLE tablename_xxx TO xxx_group;
inside of a Postgres SQL function?
1
vote
0answers
9 views
PostgreSQL for high volume transactions and for Data warehousing [migrated]
Am quite new to PostgreSQL, I have never done a large deployment using it before. But, I have good experience in enterprise solutions and I want to try and apply some of what I learned using ...
1
vote
0answers
14 views
What is causing ntoskrnl aka the System process to continue accumulating handles
I have a server which is accumulating handles on the System process aka c:\windows\system32\ntoskrnl.exe. The handles go to 18,000 in one day and keep going forever up at that rate. The server is ...
0
votes
0answers
52 views
Find query wait reason in Postgres 8.3 on Ubuntu server 8.04
I am trying to find a way to figure out why a query i'm running is waiting.
When running
select * from pg_stat_activity;
I can see my query is waiting, but there is no autovacuum or anything that ...
-1
votes
0answers
50 views
Running and optimizing Ubuntu on aws micro instance (one postgresql, one tomcat)
I had an idea for this app, so I've sat down and developed it. Now I want to run it on aws so I can showcase it to possibly interested parties. Needless to say I want to keep cost at a minimum so I'm ...
2
votes
2answers
46 views
Safe initial sync for SQL Server OLEDB/ODBC Replication
I am trying to setup one-way, transactional replication from SQL Server 2008 R2 to PostgreSQL 9.1. I'm trying out the PGNP OLE DB provider.
I can successfully create a subscription, and transactions ...
0
votes
1answer
25 views
Execute SQL statements automatically after Postgresql service starts
Would like to setup Postgresql 8.3 and above on Windows to automatically execute a series of SQL statements after the server has started.
Can't seem to find any information. Any ideas ?
0
votes
1answer
32 views
Can't get postgresql running from Homebrew with Lion
I'm new to unix and having trouble running initdb with postgresql. I installed postgres via homebrew with "brew install postgres", and have attempted to run the initdb command as follows:
initdb ...
1
vote
2answers
94 views
PostgreSQL service initdb doesn't work
I installed PostgreSQL 9.1.2 on my fedora 16 in a method similar to mentioned here, and tested it, which means that my installation is working fine.
But when I do: service postgresql initdb or even ...
0
votes
1answer
39 views
Postgresql 8.3 out of disk space on Debian Lenny
I didn't pay attention when i installed postgresql with aptitude, but it installed the databases in the wrong partition.
Now my partitions look like this:
# df -h
Filesystem Size Used ...
0
votes
2answers
33 views
How to make pg_dump less resource greedy
I have configured cron to invoke pg_dump on a daily basis using following rule:
# xyz database backups:
00 01 * * * root umask 077 && pg_dump --user=xyz_system xyz | gzip > ...
2
votes
1answer
27 views
Need help recovering PostgreSql database to a new server
As said in the topic I need some help restoring a database to a new server.
There is a production database on one server - I do a daily automated backup of that database to a remote location: pgdump, ...
1
vote
1answer
22 views
Create & Alter Schema Permissions for a Login role in Postgresql database
I have a Postgresql database with 3 Schemas (2 user defined and 1 public).
I have script that takes backup of the user defined schema's and then drops the schema's.
Now after doing some operations I ...
-1
votes
0answers
86 views
Strange summary in pgpool-admin
I want use pgpool 3.1 with three postgres 9.1 in replication mode. I edit pgpool.conf.sample-replication (code below). While testing all seems fine but when i install pgpool-admin in summary i have ...
3
votes
0answers
117 views
postgresql on Ubuntu 10.4 doesn't start on boot
I'm trying to have postgresql 8.4 start on boot on Ubuntu server 10.04 (64bit).
First, I tried putting: su -c 'pg_ctl start -D /home/postgres -l /home/postgres/serverlog' --preserve-environment ...
0
votes
1answer
12 views
Postgresql Service Start Fail How I Can Backup My Database - Cenos
I Use Centos 5 and boot from linux rescue
PostgreSQL Fail on start and I need my database on Postgresql How I can backup postgresql database without use service (copy database files and ...)
thanks
0
votes
1answer
32 views
Very often database PostgreSQL for my webapp fails
I have web application like
Nginx (proxy) + Tomcat (backend) + PostgreSQL (database).
This web application is located on amazon free tier instance (http://aws.amazon.com/free/) and very often from ...
0
votes
1answer
60 views
How do I install the earthdistance (and requirement cube) modules for Postgresql?
I need to install earthdistance, an extension for Postgresql. The page for it says:
The earthdistance module provides two different approaches to calculating great circle distances on the surface ...
1
vote
2answers
34 views
PostgreSQL Backup WAL ShellScript
I need to do a script that will backup my psql databases, i want to use the wal archive mode and not pg_dump. I've wrote this from a script i found on the web :
#!/bin/bash
#Test Script BackupSQL
...
1
vote
2answers
42 views
Drop Schema from Postgresql
I am trying to execute a few postgres commands from a bash file.
I am trying to drop a schema by writing the following line
DROP SCHEMA "xxx" IF EXISTS
I have two issues here
I am not sure how ...
1
vote
2answers
123 views
How to convert Mysql database to Postgresql in Linux?
I have a large Mysql database containing tens of tables which I need to convert to Postgresql. I have tried a couple of ancient Perl scripts which I found here and there but none of them did the job ...
1
vote
2answers
122 views
How to dump database to be used with no credentials
I am wondering how can I generate a dumped database so that it can be restored without requiring the original database username and password?
Ideally I'd like to know the pg_dumpall as well as ...
0
votes
0answers
27 views
sysctl.conf values not sticking on initdb, 10.5 Leopard PPC
I have an old Mac Mini that I'd like to put up a low-yield Rails app onto to learn about the back end. I appear to have successfully used homebrew to install postgresql and am failing at the initdb ...
0
votes
1answer
53 views
Using psql with two postgresql installations on Windows 7
I have installed two versions of Postgresql, 8.4 and 9.1. When I try to run psql it only picks up the previous psql version. For example, when I run the following line to connect to the database, ...
0
votes
2answers
59 views
How do you stop PostgreSQL from starting a cluster under linux (Ubuntu)
I need to re-build a cluster due to some incorrect parameters set when it was first created. In particular every database in the cluster is set to LC_COLLATE of en_GB.UTF8 and needs to be changed to ...
1
vote
2answers
146 views
How do I upgrade postgresl database? Incompatibility error
I installed postgresql via Homebrew.
I have the following issue after upgrading:
FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version ...
0
votes
0answers
39 views
Recovering deleted PostgreSQL database from recovered binary files
A PostgreSQL database has mistakenly been deleted from a Linux server. Some binary files of that database have been recovered (maybe all of them but I'm not sure). Is it possible to recover the ...
0
votes
1answer
45 views
How often would you run the Postgresql maintenance tasks
After reading the Postgresql documentation, we found that it's recommendable to run the Vacuum tasks daily:
We recommend that active production databases be vacuumed frequently (at least nightly), ...
2
votes
2answers
148 views
Postgresql Performance - Adjusting SHMMAX and SHMALL
I've read just about everything there is online about improving postgres performance, but the "right" values for SHMMAX and SHMALL still elude me.
The consensus seems to be SHMMAX = total_memory/4 ...
0
votes
1answer
45 views
Grant Network Access PostgreSQL 9
I have a local network and want to allow remote access to the postgres server in the another computer.
The PostgreSQL suggests the following pg_hba.conf entry but it doesn't work:
host all all ...
0
votes
0answers
32 views
PostgreSQL and S3QL for storing/accessing lots of data
We're currently using Postgres 9 on Amazon's EC2 and are very satisfied with the performance. Now we're looking at adding ~2TB of data to Postgres, which is larger than our EC2 small instance can ...
0
votes
3answers
42 views
check_postgres_checkpoint plugin error
I am using the check_postgres.pl plugin for Nagios. I am trying to monitor how long since the last checkpoint has been run using the check_postgres_checkpoint option. When I run the command from CLI ...
1
vote
1answer
42 views
Why didn't I reclaim all this size from a Postgresql table DROP?
I had a 103GB (pgAdmin III reported it as such in 'Statistics' of the table) table in Postgresql 8.4. I dropped it. Since then, its only recovered about 60GB worth of space back to the system ....
...
-1
votes
1answer
48 views
There is a WAMP packages ready for PostgreSQL usage too?
I want WAMP because I having problems with Apache and PHP, but I don't want MySQL because I'm using PostgreSQL.
There is a package ready for PostgreSQL usage too?
-5
votes
2answers
44 views
Learning PostgreSQL after using MySQL
I'm looking for a simple resource for getting the hang of Postgres after using MySQL for years. So far I've figured out \l, \d, and \c, but I'm having trouble listing the tables in my MediaWiki ...
0
votes
1answer
79 views
Issues installing postgresql with homebrew OS 10.6.8
I'm having issues installing postgresql with homebrew on my MBP running OS 10.6.8.
It finishes
sudo brew install postgresql
without any issues.
When I try:
initdb /usr/local/var/postgres
...
0
votes
3answers
89 views
Error when trying to update postgresql-libs
When I do a yum update I get the following errors:
Transaction Check Error:
file /usr/lib64/libecpg.so.6.1 from install of postgresql-libs-8.4.10-1PGDG.rhel5.x86_64 conflicts with file from package ...
3
votes
3answers
109 views
Getting more database performance - postgresql
There is a django "web application" (from hell) we are hosting on a dedicated server. After some benchmarking I found that the "Application" is amazingly bad at database operations (refactoring is not ...
0
votes
1answer
44 views
PostgreSQL memory usage on Windows Server 2008 keeps growing
We're running PostgreSQL on Windows Server 2008 (on Amazon EC2), with about 40 databases. When we first launch Postgres, it doesn't use much memory, but over time, the memory usage of ONE of the ...
0
votes
1answer
65 views
recovering Postgres database
I am new to postgres, I have to recover a database which was running in widows XP machine.
I have the zip folder of postgres,
I have extracted postgres installation in a different PC and started a ...
1
vote
2answers
46 views
Check date of a pg_dump
One a couple of servers we use pg_dumpall to create backups of our databases. I'm just wondering if there is an easy way to check if the file created is okay, and to check the date that it was created ...
1
vote
3answers
134 views
Postgres Remote Access
I am trying to connect to postgres remotely.I have followed this tutorial http://www.cyberciti.biz/faq/howto-fedora-linux-install-postgresql-server/ and have executed the following commands to see if ...
0
votes
1answer
78 views
Where's To Download PHP5-PGSQL Modules for RHEL 4
I wanna ask where and how to install PHP-PGSQL modules for RHEL4.
Because I've tried "yum install php5-pgsql" not found, I've tried "php-pgsql" the message my modules is more update than it
anyone can ...
0
votes
1answer
155 views
Dovecot - auth: Fatal: Unknown database driver 'pgsql'
I'm trying to configure Dovecot + Postfix + PostfixAdmin with postgresql support.
I successfully configured postfix to send emails to aliases for my domain, and now I want to configure actual ...
1
vote
2answers
401 views
PostgreSQL service doesn't start on Windows 7
(Not sure if this should be on Stack Overflow or Super User... please move if needed.)
When I start the PostgreSQL service on Windows 7 x64, it immediately stops.
When I check my log folder ...
