Tagged Questions

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 ...

learn more… | top users | synonyms (1)

0
votes
1answer
115 views

Why won't Postgres start after stopping it?

Postgres was running just fine (I have created a database using template0). Then, I used: $ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop --mode=smart to stop Postgres and it stopped ...
1
vote
2answers
440 views

Dependency issues installing postgresql

Here is the steps I've followed to install postgresql on Debian server: add backports deb http://backports.debian.org/debian-backports squeeze-backports main contrib non-free to ...
-1
votes
2answers
454 views

Postgresql pgdump script on RHEL5: “failed: fe_sendauth: no password supplieddatabase ”

What I'm trying to accomplish is having a pg_dump script run as a cron job. Right now I'm just trying to get the script to run by invoking it myself at the command line. I've searched the postgresql ...
0
votes
1answer
30 views

Running PostgreSQL commands in other language

Is there a way to force PostgreSQL commands (pg_ctl, postgres, initdb, etc.) to run in English and not honor the system locale? Thank you!
0
votes
1answer
164 views

Postgres SQL Installation

I installed Postgres SQL as the root user and created the user Database for it. I am trying to access the database from a non-root account through a Linux Redhat system. The software I installed ...
0
votes
1answer
177 views

Postgresql replication lag EU/US

I've a Postgres 9.2.1 server master (geolocalized in EU) and 2 slave replica (one in EU and one in US). The EU slave is used also for read queries, the US only for failover. Is it possible to have a ...
2
votes
2answers
143 views

PostgreSQL WAL archiving on secondary server

I'm using PostgreSQL 9.1 with streaming replication for failover and WAL for archiving. If I use the archive_command configuration directive on my standby server it will always fail (because the WAL ...
0
votes
1answer
533 views

Password authentication failure in PostgreSQL 9.1 from remote client

I run PostgreSQL 9.1.9 in Debian Squeeze server (using backports). The contents of pg_hba.conf file is: local all postgres trust # TYPE DATABASE ...
1
vote
2answers
1k views

How to migrate old redmine server to a new one upgrading version and changing DB engine

I am planning to migrate my Redmine (1.0.5) to a new machine. I would like to upgrade Redmine to latest version and change the database from MySQL to Postgresql with this migration. My plan A is: ...
2
votes
1answer
89 views

High shmmax value in Redhat 6.3

We are using Redhat 6.3 with 30G RAM to host our Postgres server. The (default) shmmax value is 68,719,476,736 In some forums I have read that having an shmmax value larger than the RAM causes ...
2
votes
2answers
7k views

postgresql installation : initdb data directory not empty?

I am trying to create the database and I am a newbie. When I install PostgreSQL, I gave this command sudo yum install postgresql postgresql-server and later I modified the config file sudo vim ...
0
votes
1answer
272 views

How can I solve the “split brain” issue with only 2 physical servers?

I have 2 physical servers, each will contain 2 VMs; a VM with Postgres (9.2) running, and a VM running some Python software (which will connect to the Postgres server). I'm not tied to anything in ...
0
votes
1answer
71 views

Linux server responds to postgresql querys and ssh only when pinging the server

I have a problem. My developers are using one of my local servers that is located in our office. The server is running PostgreSQL and when they try to make a query to it, it just lags and then gives ...
0
votes
1answer
695 views

Why is hash join slow in postgresql 9.1?

I transfered my DB from Postgresql 8.4 to new server with Postgresql 9.1. Size of DB is 9.9GB Data directory is situated on ssd 60GB disk. And server has 16GB RAM and 16 proccessor cores. But today ...
1
vote
0answers
215 views

segmentation fault trying to start ldap

My PDC using Samba 3.6 with LDAP (the latest version) works very fine as long as I use hdb as the backend. Nevertheless, I change the backend to sql I receive the following error while trying to ...
3
votes
1answer
2k views

Maintenance of tables: do I need to REINDEX a table after truncating and repopulating?

I have a table with about 2 million rows in it of transactional data that we use for analytics. Every week we reload this with new data, so we've been using TRUNCATE to clear it out and then inserting ...
0
votes
2answers
408 views

SSH direct stdin and stout to and from postgres client

my local can connect to remote , but it cannot connect to dbserver. remote can connect to dbserver (with psql). I want to run sql scripts from my local against the db. I am looking to a way to open ...
0
votes
1answer
88 views

Solutions for a growing Postgresql database on Amazon EC2?

I've been doing a lot of research into scaling issues on Amazon EC2, especially growing databases. I looked into how I can make the database more solid and sound (I use PostgreSQL). Many sources say ...
1
vote
0answers
83 views

How can I store the Postgresql data on the EBS Volumes and not on the Root Volume?

My PostgreSQL database is currently stored in the cloud. Normally, when creating a PostgreSQL database, all the data is stored on the root volume of the EC2 instance. How can I make sure all the ...
0
votes
1answer
107 views

How does data storage on Amazon EC2 work especially for databases?

I've been playing around with Amazon's Web Services for over a year now, however I don't quite understand how it works. When I for example select an AMI of my choice from the EC2 console and I ...
0
votes
2answers
79 views

Checking that PostgreSQL and Apache are running on Ubuntu?

I am trying to learn the best practices for checking that Apache and Postgres are running on my server. If either of them have stopped, I want to auto-restart these services. I'm using Ubuntu 12.04 ...
1
vote
2answers
128 views

PostgreSQL 8.1 out of space and stopped, data directory is empty

I used PostgreSQL 8.1 on Gentoo/Linux 2.6.14r5. My db server's disk space looks like below: db postgresql # df -l Filesystem 1K-blocks Used Available Use% Mounted on /dev/sda3 ...
-1
votes
2answers
2k views

PostgreSQL server failed to start: request for a shared memory segment exceeded your kernel's SHMMAX parameter

I increased PostgreSQL's shared buffer (among other settings) to 4096M and now PostgreSQL fails to start, giving the error message below. Should I change the kernel's SHMMAX parameter to 4096M? The ...
0
votes
1answer
201 views

SSH tunnel to a postgres database [closed]

Currently I develop on a remote dev server. I SSH into the dev server (using SSH keys) as ssh -p 22222 user@devbox.com Then from the dev server, I connect to the database over the local network ...
1
vote
2answers
317 views

Install specific version of package (postgresql) along with most recent version on gentoo

I upgraded our gentoo server, got lost in the messages and, to make the story short, I ended up removing my postgresql 9.1 BEFORE I run a pg_upgrade to 9.2.. Then I discovered that pg_upgrade requires ...
1
vote
1answer
485 views

postgres updated from 9.1 to 9.2, required database update fails

On going from postgres 9.1 to 9.2, it says that the data bases need to be upgraded so on giving the upgrade command I give and get the following $ sudo service postgresql upgrade Stopping postgresql ...
0
votes
1answer
114 views

Introduce artificial delay in streaming replication

I have set up PostgreSQL with streaming replication. It replicates very fast, in a fraction of a second. I'd like to insert a delay of 5, maybe 10, maybe 15 seconds, so that bugs related to ...
0
votes
0answers
101 views

Postgres using only 500 MB of RAM of the available 4 GB

We recently moved to running postgres server on it's own VM and tracked the memory usage of the VM. Here is what I found: That the postgres is only using 500 MB of the available memory on the VM. ...
1
vote
3answers
2k views

sudo /etc/init.d/postgresql restart (how to chose which installation?)

I have two postgresql installations: $ sudo /etc/init.d/postgresql status 9.1/main (port 5432): online 9.2/main (port 5433): online I was used to restarting the postgres database doing a: $ sudo ...
0
votes
1answer
125 views

Postgresql Database Connectivity

How secure is connecting Postgres Database using phpPgAdmin through port 80? What is the difference between accessing postgres DB through database client tools through port 5432 and acccessing it ...
6
votes
1answer
485 views

Using Postgres Basic Auth in NGINX to add query result to Proxy HTTP Header

We are trying to use the ngx_postgres module to do basic authentication through NGINX. We want to retrieve a value from the query result-pair and add it to the HTTP Header, and then proxy this to ...
1
vote
1answer
2k views

Why can't I connect to my PostgreSQL database?

I'm trying to install tentd-admin. The install fails during this step: $ DATABASE_URL=postgres://localhost/tent_server bundle exec rake db:migrate I also tried this: $ ...
1
vote
1answer
66 views

How to apt-get install a package for Ubuntu Quantal from Ubuntu Precise 12.04

On Ubuntu Precise 12.04, the package osm2pgsql is currently at 0.70.5+r25090-2ubuntu2. However I need to install a newer version 0.80 but apt-get update does not provide the newer version. Question: ...
1
vote
1answer
270 views

ZFS / ZFS send for database replication

Let's say I've got a somewhat important database but one where I don't actually care about every transaction. Before you get snarky -- it is a database storing zabbix status data, so I honestly don't ...
3
votes
2answers
1k views

Too much I/O generated by postgres stats collector process

I am using XenServer with several virtual machines having local postgres databases. Even when all applications are unused and the databases are idle, each vm causes constant storage network traffic ...
1
vote
1answer
215 views

Benefits of Heroku Postgres

Heroku Postgres seems like a nice service, that eases the pain of database management. Personally I have no experience in managing DB clusters, so that's why I like the service very much. However, I ...
-1
votes
1answer
286 views

pgpool-ii show server as down, but server is running fine

I am using postgres 9.2 with streaming replication. I have 1 master DB and 2 standby DBs, it's hosted on amazon EC2, each has it's own server. On separate server i have pgpool(3.2.3) that does load ...
0
votes
2answers
149 views

Postgresql performance enhancement

I have my setup like this: Two separate instances of the database on a clustered environment. Both instances are on dedicated servers each carries up to the standard configurations. Instance one ...
0
votes
2answers
2k views

pgAdmin cannot connect to PostgreSQL 9.1

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM. The host's port 5432 forwards to VM's port 5432. pgAdmin Error: Error connecting to the ...
1
vote
1answer
2k views

Postgresql 9.2 “invalid locale name” on Ubuntu 12.04

Today I installed Postgresql 9.2 on Ubuntu precise via apt.postgresql.org – all was relatively painless until I got stuck in a "invalid locale name: it_IT.utf8" error: root@ubuntu:/tmp# sudo -u ...
5
votes
3answers
2k views

PostgreSQL slow commit performance

We are having some problems with a PostgreSQL configuration. After some benchmarks I found out that very simple queries are taking a relatively long time, upon furter inspection it appears that the ...
0
votes
1answer
162 views

In Mac OS ,Postgres after changing data folder location . Unable to start Postgres database . it doesnt give any error

I'm trying to use Postgres on a Mac. After changing the location of the data folder, postgres didnt start. It doesnt give any error message. I've copied the data folder from another location, and ...
1
vote
1answer
1k views

PostgreSQL raw query vs “Function returns TABLE” - insane difference in performance. Why?

I work with the PostgreSQL and it is used for reporting. The way it is configured currently is as follows: There is a complex query which returns report data, like this: select Column1 as Name1, ...
2
votes
2answers
2k views

Postgres INSERT ERROR: permission denied for schema public

In Postgres I created the following table inside a db called testing: CREATE TABLE category_google_taxonomy ( category_id integer references category ON UPDATE CASCADE ON DELETE CASCADE, ...
1
vote
1answer
233 views

How to grant in Puppet a global permissions to PostgreSQL?

Official postgresql module from puppetlabs allow granting privileges on specific database. postgresql::database_grant{'grant to myuser': privilege => 'CREATE', db => ...
0
votes
2answers
154 views

RAID config for write heavy postgresql 9.2 database with four disks

I have a server with 32GB ram, one intel E3-1245 and four 15k SAS disks with a BB LSI MegaRaid controller. I wan't the optimal performance for my server, which will be pretty write heavy at times, and ...
1
vote
1answer
146 views

Extracting PostgreSQL dump in a disk efficient manner

I have a 15 GB compressed PostgreSQL dump (as a pgbackup), that when extracted is closer to 60 GB. I have a cloud server with only 69 GB of free space (54 GB after the pgbackup is copied onto the ...
1
vote
1answer
679 views

Postgres's pg_basebackup never finishes creating backup

I'm attempting to move files to another server to setup a slave. I have a database on one Postgres Server and am attempting to create a file-based backup using pg_backup. However, it never finishes ...
0
votes
1answer
53 views

DB2-Express-C and Postgresql using raw harddrive as datastore

I have a system running Solaris with 2 harddrives. One holding the OS and the other unpartitioned. I was thinking about using the second as database space. My question is, if it is possible to let ...
2
votes
1answer
608 views

Postgresql unintended upgrade to 9.2.3

OK, so I'm relatively new to linux. Some months ago, I managed to set up a website using Amazon's build of CentOS, PHP and Postgres 9.1. I'd done an initdb on /pgdata which was mounted on an Amazon ...