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)

2
votes
2answers
878 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
190 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
252 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
135 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
1k 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 ...
4
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
132 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
857 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, ...
1
vote
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
174 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
0answers
76 views

how to forward pgadmin request via another box with iptables

I have two remote Linux boxes. I can access box1 directly but need to ssh into box2 from box1. What I am trying to accomplish is use iptables to forward request from pgAdmin to box2 via box1. I.e. I ...
0
votes
2answers
116 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
123 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 ...
0
votes
1answer
592 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
52 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
540 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 ...
0
votes
1answer
56 views

Postgresql does not launch [closed]

I just installed postgresql 9.1 on my ubuntu server precise I installed postgres on an ubuntu workstation before and despite following the same steps (documented) nothing works. When i do : sudo ...
0
votes
2answers
147 views

PostgreSQL, automate REINDEX, Windows environment

I have a couple of PostgreSQL tables (9.1) which are inserted to / deleted from often. Over time they suffer from index bloating even though the autovacuum is configured and runs regularly. I'm ...
-1
votes
1answer
1k views

Why is Postgres not starting? [closed]

Somehow my Postgres is not anymore starting: # psql psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket ...
0
votes
0answers
144 views

Postgres segfault on Ubuntu 12.04 64

i have a unbelivable problem: Ubuntu server 12.04 64 bit running on Wmware Infrastructure, postgres 9.2 and django connecting via psycopg. Randomly postgres crashes with segfault, si i restart it an ...
1
vote
2answers
764 views

What is a typical Compression Ratio for an SQL Database backup file? [closed]

One of my clients want us to give a safe estimate of how much disk space does a compressed SQL backup file take. They need to size their server hard disks accordingly. We can rouhgly estimate the ...
2
votes
0answers
254 views

Postgres roles best practice implementation

Folks, I could use your help making my Postgres user access control design better and more aligned with best practices. I'm helping roll out a small production Postgres server but I am not a DB ...
0
votes
2answers
82 views

postgres: how to store latex code within a text column

i'm trying to put some Latex code in a PostgreSQL Database. Created a table with cid as Serial type and code_text as text type. After an INSERT Statement INSERT INTO texcode (code_text) VALUES ...
1
vote
1answer
2k views

Postgresql unrecognized, even though it's installed

Postgresql 8.4 seems to be installed properly, according to this: sudo yum install postgresql Loaded plugins: product-id, refresh-packagekit, rhnplugin, security, subscription-manager This system ...
1
vote
1answer
2k views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
1answer
111 views

Allow two login methods for the same user in PostgreSQL

I have a PostgreSQL server running on a remote Debian Squeeze server. I would like to login with the user postgres using the ident and md5 method at the same time. The former is needed for debian ...
1
vote
1answer
168 views

multiple postgresql installations in osx

I have multiple installations of postgres on my machine, and would like to narrow down to a single installation (macports flavor). I believe that OSX comes shipped with some sort of package, but I am ...
0
votes
1answer
100 views

GRANT/REVOKE on functions

I am using the has_function_privilege, to check and see if a certain user can access a function in my database. However, if I use REVOKE to revoke access, has_function_privilege still returns true: ...
0
votes
1answer
114 views

How to monitor a remote Postgresql Amazon EC2 database through Munin?

How can I monitor a remote postgresql database on Amazon EC2 using Munin? I would like to graph the number of reads, writes, and total database operations.
0
votes
1answer
111 views

How do I install a previous version of Postgresql in debian?

I am running debian squeeze. I want to install a previous version of postgresql. The current version in the postgres debian repository for 9.0 is 9.0.12. I specifically need to get 9.0.8. How can ...
1
vote
2answers
1k views

How can I restore a microsoft sql server database backup to postgres?

I need to take a Microsoft SQL Server database backup (dump) file and import/restore into a PostgreSQL database. Does anybody have some sort of transform script (maybe a perl/sed/awk script) that ...
0
votes
1answer
350 views

Setup HA postgres database, failover concept

I want to setup a HA postgres database. I setup master and slave database with synchronous streaming replication on different physical servers. When there is an error in the replication, the slave db ...
1
vote
1answer
266 views

How to upgrade Postgres 9.2.2 to 9.2.3 on a CentOS box

What is the correct way to upgrade Postgres to 9.2.3? (I would prefer not to have to delete/restore my databases if possible.) # rpm -qi postgresql92-server Name : postgresql92-server ...
1
vote
1answer
378 views

Postgres WAL files clean up

Is there any way how I can clean up postgres WAL files ON MASTER SERVER - SLAVE is OK, but master has wal keep segment set to 2000 and this is causing disk space usage to grow. I'm looking for a way ...
0
votes
1answer
291 views

Facing authentication error on postgres 9.2 -> dblink functions

I am using postgres 9.2 and when executing function dblink facing a fatal error while trying to execute dblink_connect as follows: SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 ...
1
vote
1answer
31 views

Use switch or direct link

We are thinking of setting up a high availability PostgreSQL server with master-slave configuration (possibly multiple slaves). Should we use a direct link between a master and a slave or let them ...
0
votes
2answers
760 views

Native Postgresql 9.2 Streaming Replication

I'm trying to build up native postgresql 9.2 streaming replication in the Amazon cloud. According to documentation, I've set up everything correctly - but at the slave I get these logs: 2013-02-04 ...
1
vote
3answers
155 views

How can a larger delay be placed between two interdependent upstart or /etc/init.d services?

My PostgreSQL service must start after OpenVPN, and when I check the order rc.X directories they are listed as S16openvpn and S19postgresql, so they are in the right order. However connecting to a ...
2
votes
1answer
355 views

PostgreSQL and Mongodb in production

We have a product that uses Postgres for RDBMSish data (accounts, billing, etc.) and MongoDB for each of the accounts data (which obviously can't be maintained on Postgres). In local development we ...
0
votes
1answer
184 views

Why is autovacuum using so much IO when running on a partition's master table after upgrading PosgreSQL from 8.4 to 9.1?

We have an application where we are collecting timestamp-based data. Since a month of data goes over 30M rows (and growing each month), we decided to partition the data on an year-and-month basis. We ...
0
votes
1answer
647 views

Can't get postgres and kerberos (gss) working together

I am trying to get postgres and kerberos, via GSSAPI, working together. Having trouble at this point. It does not help that I am really a newbie for both technologies. I have both postgres and ...
2
votes
2answers
93 views

What's the most convenient method to ensure that PostgreSQL 9.x hot standy replication is still functioning properly

Assuming that I've got it hot server replication all set up nicely, what's the easiest or most convenient steps I can take periodically to ensure that the hot server replication is still working fine ...
0
votes
1answer
149 views

Is it possible to dump a postgresql db and restore it in mysql?

I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?
0
votes
1answer
305 views

Why isn't phpPgAdmin connecting to remote servers?

I am currently in the process of migrating some systems, and as part of this I wanted to consolidate phpPgAdmin to a single instance. But I am unable to make phpPgAdmin connect to remote servers. ...
0
votes
2answers
478 views

Cannot upgrade PostgreSQL on Ubuntu

When I run apt-get upgrade, I get the following error : dpkg: dependency problems prevent configuration of postgresql-9.1: postgresql-client-9.1 (9.1.7-0ubuntu12.04) breaks postgresql-9.1 (<< ...
2
votes
1answer
1k views

what does peer authentication mean for postgresql?

I'm trying to log into my DB and am getting this error... root@---:~# psql -U user database psql: FATAL: Peer authentication failed for user "user" What does this mean? I'm pretty sure I can fix ...
0
votes
0answers
85 views

postgres process priority

We've noticed on our CentOS PostgreSQL database servers that every postgres process is no longer running at the default nice priority of '0'. They are running at a lower priority (2). Is Linux ...
2
votes
0answers
68 views

Restricted LDAP mimic server backed on SQL

I may not be an expert on the subject, but it seems to me that 99% of any LDAP server installation is used only to provide user authentication credentials and nothing more. Given this restricted ...
-2
votes
1answer
627 views

Alfresco couldn't start. Why?

I have alfresco on my VM. When I try to start alfresco I got an error "postgresql could not be started" such as following : /opt/alfresco/postgresql/scripts/ctl.sh : postgresql could not be started ...