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
0answers
19 views

How to install Nomtimatim in postgresql (windows)

I am trying to do geocoding in the postgresql, and I have already installed TIGER geocoder successfully. Then, I want to use Nomtimatim in postgresql. However,since the installed guide ...
-4
votes
0answers
14 views

issue with Postgresql password on ubuntu [on hold]

I can't seem to access the password to postgresql. I used sudo -u postgres psql postgres postgres=# \password postgres Enter new password: Enter again: It was successful here. But after logging ...
0
votes
1answer
10 views

.pgpass file does not set default username to connect as

(Debian 8) My .pgpass file is at my home folder (admin) I and using the right format as indicated in the documentation hostname:port:database:username:password The same fields I put there work ...
0
votes
1answer
18 views

NAS suitable for this situation? [closed]

I work from home and am considering getting a NAS. Would using a NAS be suitable for my situation: I alternate working from a desktop and laptop, both of which run Linux I use PostgreSQL a lot along ...
-4
votes
2answers
51 views

Does anyone know of a good free tool that can be used to ping our Postgres database server to determine if it is running or not? [closed]

I'm looking for a free tool which runs on my desktop (not the server itself) that will periodically test to see if our database server is up and running properly. Ideally, it should also be able to ...
0
votes
1answer
31 views

fail to start postgresql when used with vagrant

Trying to start postgresql on a Virtualbox VM managed by Vagrant I have the following error: LOG: could not link file "pg_xlog/xlogtemp.29" to "pg_xlog/000000010000000000000001" (initialization of ...
0
votes
2answers
38 views

How to grant access to /var/run to postgres on CentOS?

After installing postgres-9.3 via yum in my CentOS 7, its default configuration puts socket in /tmp directory. I have httpd (installed via yum as well) which is by default managed by system.d with ...
-1
votes
0answers
62 views

Cannot connect to postgresql server running on CentOS 7

I've already done my best to search for an answer using google and using StackExchange, and if there was an answer there, I just didn't understand it and/or was confused by the language. Either way, ...
1
vote
0answers
23 views

PostgreSQL 9.3 - Move table to tablespace - Slow? [migrated]

I need a help with moving table to a different tablespace. I have a really large table that is not queried much often so I've decided to move it from tablespace on SSD to tablespace on HDD and save ...
0
votes
0answers
47 views

OS X Yosemite Server - Wiki stops working

the last couple of days I have noticed that the Wiki-Server on OS X Server seems to crash. When I call up the wiki's website I get the following message: Caught exception "Connection to DB failed" ...
1
vote
2answers
42 views

Automate pg_dump in a bash script

I am re-learning bash after years of not using it very much and need to figure out a way to automate pg_dump of a single database to a directory. Currently I manually ssh into the box, su to postgres ...
0
votes
1answer
65 views

No space left on device error

I can no longer generate new columns in my database. My stack is below. I am new to managing my own server and am unfamiliar with Apache, Ubuntu and AWS. Currently I am receiving an error saying ...
1
vote
0answers
84 views

PostgreSQL - Invalid byte sequence for encoding “UTF8”: 0xe7 0x75 0x20

Here is the problem : Everything worked fine with my postgresql system until I decided to click on the "rotate logs" button in the server status tab (from pgAdmin). After that, I faced this issue, ...
0
votes
0answers
51 views

Postgresql Connection Timed out

when I am connecting to psql on remote server >psql -h {hostname} psql: could not connect to server: Connection timed out (0x0000274C/10060). Is the server running on host "{hostname}" ...
-1
votes
0answers
13 views

How can we configure the Streaming Replication(master-slave) on single SAN storage in PostgreSQL? [migrated]

I want to configure the Streaming Replication in PostgreSQL.My data directories of Primary and Standby are in same SAN storage.Is it Possible to do replication.
0
votes
1answer
40 views

MD5 pw encryption in postgresql using CREATE USER WITH PASSWORD

So I have postgresql database and in pg_hba.conf file I am authenticating users via md5. I typically create users using the command: CREATE USER username WITH PASSWORD 'password'; From the ...
0
votes
1answer
57 views

How to import postgresql file on Linux with space in path?

If I try to import an sql script with a space in path, the file is not found. mypsqluser=> \i /home/markus/Documents/Projekte/My App/Installation/server_sql_script.sql ...
0
votes
2answers
52 views

Tuning Tomcat java app with Apache reverse proxy and Postgresql

Looks like my apache reverse proxy may be acting as the bottleneck and bogging down the number of requests users can make. I run Apache and Tomcat on server1, which has 96 gb RAM, rhel5 x64, 24 ...
0
votes
1answer
33 views

Postgresql 9.1 -> 9.4 migration problems

I've run a quick and dirty debian 7 -> debian 8 upgrade today, and lost my postgresql 9.1 installation. By "lost" i mean that i can't start it from init script (i simply get no output; 9.4 goes okay, ...
0
votes
1answer
33 views

Ubuntu 14.04 having two postgres server, removing one

after installing postgres using apt-get and adding the repo for 9.4, I have two versions, 9.3 and 9.4 running. How can I remove 9.3? apt-get purge removes both actually. Thanks ins advance
0
votes
0answers
21 views

Fallback to backup server upon failure of main server without third machine

I will soon need to setup a database server on a budget. We are planning to use Postgres on Ubuntu (most likely) and we'd like to have a backup server. For replication, I think I'll just use ...
0
votes
0answers
31 views

pgpool2 stucks in “idle in transaction”

We have a setup with two postgresql servers configured as master-slave (streaming replication). The application servers (Odoo) should connect through pgpool2. All is fine if I connect the application ...
0
votes
1answer
33 views

How to export a Heroku-friendly Postgres dump from Ninefold?

I am trying to migrate my postgres database from ninefold to heroku. The command I'm using to export is: PGPASSWORD=password pg_dump -h ipaddress -p port -U user -d database -Fc --no-acl --no-owner ...
0
votes
1answer
10 views

Downsides to indefinite replicate streaming delays?

I have a db server that's sole purpose is for analytics querying. It's running as a hot standby, but long running queries are failing due to max_standby_archive_delay and max_standby_streaming_delay ...
0
votes
0answers
16 views

apache2 mod_dbd and postgresql

I'm trying to rewrite url using dbd. Everything looks ok, except few things: It doesn't work It doesn't show any error (LogLevel Trace8) It doesn't show any connection to database (postgresql.log ...
1
vote
0answers
11 views

Does a PostgreSQL hot standby cache streamed WAL segments?

If pg_xlog_replay_pause() is used or max_standby_streaming_delay is set, are unapplied WAL segments stored on the hot standby? I'd like to be clear if a long-running query is keeping WAL segments ...
1
vote
1answer
57 views

Why would updating postgresql-client uninstall postgresql?

On a Debian 7 server, apt-get was offering me to upgrate the following 2 packages: postgresql-9.1 and postgresql-client-9.1. Since I didn't want to restart the database server, I decided only to ...
0
votes
0answers
61 views

After upgrading to PostgreSQL 9.4, unable to connect from localhost

I have recently upgraded from Debian 7 to Debian 8 and from PostgreSQL 9.1 to 9.4. I am not able to connect to my database server even from pgAdmin III on localhost. I have in my postgresql.conf the ...
1
vote
0answers
48 views

Postgres streaming replication over Internet

all: I want to set up two PostgreSQL servers, one as master server and the other one as a hot standy, using streaming replication. I have done this before in LAN environments, but I would like to ...
0
votes
1answer
24 views

Can't access remote PostreSQL

I just moved my office and now I can't get to PostgreSQL on my Windows web server. I changed the pg_hba.conf file to the new IP address. I made no other changes to the server or my computer. One ...
7
votes
1answer
372 views

su: /bin/bash: Resource temporarily unavailable

Unable to switch user to postgres. Ulimit settings for postgres user is set with reasonable limits. We are not hitting max. No errors in /var/log/messages. Error: BETA -bash-4.2# sudo su - ...
4
votes
1answer
60 views

PostgreSQL limiting connections to fewer than max_connections?

I have a PostgreSQL 9.4 server that seems to be limiting connections to fewer than what I have defined in max_connections. I have max_connections set to 300. SHOW max_connections; max_connections ...
0
votes
0answers
54 views

postgres sql returning "more than one row returned by a subquery used as an expression

Postgres sql is returning: more than one row returned by a subquery used as an expression The data base format is: rpt_rec_num | wksht_cd | line_num | clmn_num | itm_val_num ...
1
vote
1answer
39 views

Changing tablespace on table with streaming replication

I've been searching for answers for a while know but can't find any reliable source. We have 2 postgres servers that replicates using streaming replication. I now need to move some tables to a ...
0
votes
0answers
25 views

openshift gear borks and restarts

I have a Django application on Redhat OpenShift that uses a postgresql database. I use the free plan with 1 small gear using: Python 2.7 PostgreSQL 9.2 For a certain command I get thrown out from ...
0
votes
0answers
39 views

How to configure PostgreSQL password? on a new VM

I installed my postgresql like this. sudo apt-get update sudo apt-get install postgresql postgresql-contrib and accessed it like this sudo -i -u postgres and my a gist of my pga_hba.conf # DO ...
0
votes
1answer
199 views

start postgres 9.4 server from Windows commandline [closed]

I am trying to start the postgres erver from the Windows command line but it keeps failing with the same error: 2015-04-14 10:25:19 GST LOG: could not bind IPv6 socket: No error 2015-04-14 10:25:19 ...
0
votes
1answer
23 views

Postgres protected access

I am trying to configure my Postgres instance so that only the local machine and my machine (over internet) should be able to access the database. The postgresql.conf file has parameter ...
0
votes
1answer
56 views

PostgreSQL - SQLSTATE[22007]

I have a box running Debian Wheezy, It is only used to operate Airtime (Icecast, LiquidSoap) It was working fine, after loading some more data into folders and editing WATCHED FOLDERS, I am getting an ...
-1
votes
1answer
187 views

Migrate OTRS database from PostgreSQL to MySQL

OTRS supports PostgreSQL and MySQL databases. I'm using PostgreSQL 9.1 for my OTRS 3.2 but I want to migrate to MySQL 5.5. Is this possible? How?
0
votes
1answer
150 views

Migrate data from postgresql 8.4 to postgresql 9.4 in 2 different servers

I have a problem with postgresql as below: I have a server CentOS 5.9 install postgresql 8.4. It is running for my production and Data Size = 300 GB. At the moment, I need migrate all data in ...
0
votes
0answers
12 views

Postgres 9.3 maximal cluster size with streaming replication [duplicate]

First, I quote from https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial: In Streaming Replication, the master and the standby have special processes called the walsender and walreceiver ...
0
votes
1answer
79 views

Syslog-ng and Logrotate creating sparse files

We've been using syslog-ng to log our postgres logs. On top of it we run logrotate every 5 minutes which also gzips the files. Recently, we've noted that these postgres logs contain a lot of null ...
0
votes
0answers
95 views

CentOS 7 Cluster with load balancer

I'm trying to understand how clustering works in CentOS 7. I'm not a cluster expert!!! What I'm trying to do is to have three clustered services: httpd, mariadb (mysql) and postgresql. I've managed ...
1
vote
1answer
65 views

The more threads the less IOPS?

I've just started trying out AWS. I have a Postgres micro instance on RDS and I'm running a crawler on a c4.large. When I have just one spider (one thread), I get about 10 write IOPS. but if two ...
1
vote
0answers
54 views

Monitoring maximum number of locks in PostgreSQL with Nagios

I'm wondering if the limit for the number of locks in PostgreSQL is fixed, or if it depends on the number of open connections. The docs say the limit is max_locks_per_transaction * (max_connections + ...
0
votes
1answer
143 views

Does PostgreSQL perform on Windows as well as on Linux

This topic was brought up in 2011, and the consensus was that there were design considerations that would give PostgreSQL a leg up on Linux. It is now 2015, has that changed? If there are things that ...
0
votes
1answer
136 views

Support for Postgres broken in HHVM 3.6.0

I keep getting Uncaught exception: Could not open extension /etc/hhvm/extensions/pgsql.so: /etc/hhvm/extensions/pgsql.so: undefined symbol: _ZN4HPHP13PDOConnection5sweepEv When I try to start up ...
0
votes
1answer
76 views

Reduce the size of main/base mysterious buildup

Using PostgreSQL 9.3. I had a long-running query updating around 8M rows. Something obviously went wrong. 2 days later I got a low disk space alert. I stopped the query and this is what I saw. ...
0
votes
1answer
25 views

Postgres replication via different interfaces

I have one PG master server that replicates itself to one slave server. Also I would like to replicate this master to slave that is in another network. Master has 2 interfaces, and there are ...