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
2answers
649 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
210 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
66 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
1k 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
106 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
140 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
95 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
111 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
109 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
985 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
311 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
257 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
332 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
255 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
691 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
149 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
347 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
170 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
579 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
85 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
128 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
284 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
429 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
81 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 ...
1
vote
0answers
64 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
570 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 ...
1
vote
2answers
323 views

Can't connect to Postgres in production

I'm trying to connect to my Postgres instance on a local IP, which I can connect to with no problem using the psql -h localhost command. However, which trying to run via rails, I get this: $ rails c ...
1
vote
0answers
302 views

Shared Memory Issue on Postgres Installation on Mac OS X [closed]

During the Postgres Installation on Mac OS X 10.7, I get the following message: Your system seems to be configured with less than 32MB of shared memory, which is required for this application. ...
2
votes
1answer
393 views

Should a connection pooler be run on my database server or my app server?

I'm getting ready to start using PGBouncer, but I'm unsure of whether it should be used on my database server or on the app servers. If it's on the app servers, there will necessarily be multiple ...
1
vote
0answers
332 views

security group not allowing connection to postgres ec2 aws

Hey im having some trouble allow remote connections to postgres from other ec2 instances using the named security group feature to rules. I have set the listens directive in postgres.conf to "*" and ...
2
votes
1answer
73 views

PostgreSQL 9.0 implicit transactions not rolling back

I'm using PostgreSQL 9.0 in production, and have started noticing that statement errors abort an implicit transaction that never gets rolled back. This same issue doesn't appear on my development box, ...
6
votes
4answers
1k views

PostgreSQL scaling up to 64 cores?

In this Computer World article, it specifies that PostgreSQL can scale up to a core limit of 64. Does this mean for one multi-core processor of 64 cores? Or multiple processors with fewer cores? The ...
2
votes
1answer
134 views

Why doens't my Postgres user have permissions to add a Postgres database?

First, I ran: sudo su postgres createuser -U postgres foouser -P which worked fine, and I ran: createdb -U foouser -E utf8 -O foouser foodatabase -T template0 and got "permission denied: cannot ...
-1
votes
1answer
65 views

I'm able to login via “psql” as “posgres” with any linux user - is this a security issue?

I used sudo su postgres and set up my database while logged in as the linux user postgres. After exiting to my normal shell, logged in as my non-root user, I can simply use psql -U postgres and then ...
0
votes
2answers
53 views

Problems locating Redmine database

I have an active redmine but I can not find the database where it is running right now. It should be on PostgreSQL but the database where it should be running is empty. Does anybody have any idea how ...
2
votes
0answers
70 views

Flipping between databases

I have inherited a tomcat application running on RHEL that connects to a local postgres database. We have a total of 8 servers in multiple states running this. Each server actually has two different ...
0
votes
1answer
91 views

PostgreSQL Page-level locking

I'm fairly new to postgresql. I've checked out the documentation and I can't find anything about how to do page-level locking. I understand that I can set a table into a locking mode like this: LOCK ...
2
votes
1answer
2k views

Granting rights on postgresql database to another user

I'm trying to set up a system with a PostgreSQL database per user, with a PHP-FPM resource pool for an associated account. I need to grant all privileges on the database to the other user, but it ...
2
votes
1answer
305 views

PostgreSQL RAID configuration

I'm stuck how best to configure disk array. We have Hp P2000 G3 disk array with 24 SAS physical disks 300Gb each. We need to configure this array got 2 copies of PostgreSQL 9.2 because two different ...
3
votes
1answer
1k views

Strange high CPU I/O wait on postgresql server

I'm really struggling with a performance issue currently, where all my database queries takes up to a 1000 times more than normally, when my database server is under "heavy" load. I have a server ...
1
vote
1answer
317 views

what is the difference between “”psql“” and “”postgres“” commands?

I'm running mountain lion and I am getting very different responses when I run the psql or postgres commands. For the former I get: > psql ovatsug25=# For the latter I get: > postgres ...
0
votes
1answer
697 views

Install pgadmin in debian server [closed]

I have got pgAdminIII-1.14 source code from the official website. Now I'm trying to compile it, on a Debian Squeeze machine. At first I did: ./configure and I got this error: configure: error: ...
1
vote
1answer
938 views

Cannot login to Postgrest database despite setting password for user 'postgres'

I'm trying to use pgAdmin III to manage my Postgres database. Here are the commands I've run on my machine: sudo apt-get install postgresql Then I installed the pgAdmin III application: sudo ...
0
votes
1answer
301 views

Remove a non existing postgres cluster

I have a postgres 8.4 install on ubuntu 10.04. I created a cluster on a disk that is not mountable anymore. Now I want to remove postgres but when I do apt-get remove postgresql-8.4 I get: dpkg: ...
1
vote
2answers
919 views

How to set up postgresql on EC2 so my data will be backed up and safe?

I am in the process of setting up a very small web-app that I hope to eventually grow into something larger. For now it is a near-zero-budget personal project so I don't have a lot of resources to ...
-1
votes
2answers
124 views

How to load balance when database and application running on same instance in Amazon EC2

I have the situation where I am running my application and Postgresql database on same Ec2 instance. Data of Postgresql gets saved on another EBS Volume different from the Root volume of the instance. ...
2
votes
1answer
53 views

What is the most efficient way to connect my application on one VM to my Postgres DB on another VM?

I have 1 physical machine with 2 VMs (VMWare esxi) - one for database (PostgreSQL 9.2.1), and one for application. I'd like my application to connect to my database in an efficient way, and I've heard ...