Questions tagged [postgresql-9.3]

PostgreSQL is a powerful, open source object-relational database system. Please use this tag for questions related specifically to version 9.3 of this software.

Filter by
Sorted by
Tagged with
0 votes
1 answer
1k views

Setting password authentication for default Postgres account

I'm trying to resolve an issue that was found during a Nessus scan involving the default postgres account not having authentication. https://www.tenable.com/plugins/nessus/10483 I've been trying to ...
user avatar
0 votes
1 answer
178 views

Manually start PostgreSQL 9.3 after installer quietly refuses to install Windows service

I need to access a small database from about four years ago. I have the original installer and the entire original directory including the data folder. Unfortunately the installer for 9.3 and 12.0 ...
user avatar
  • 131
0 votes
1 answer
2k views

Unable to connect with public postgresql rds instance : Connection Timed out

I created a basic test PostgreSQL RDS instance in a VPC. It is public and VPC security group. The security group whose configuration is as follows: Inbound Rule: Type: PostgreSQL Protocol: TCP Port:...
user avatar
  • 1
3 votes
5 answers
11k views

PostgreSQL won't start after moving datadir on Centos 7

I've installed PostgreSQL 9.3 on Centos 7. After installing I could start the system service and login to psql. I want to move the PGDATA folder to another partition, so I tried several things to ...
user avatar
  • 551
3 votes
1 answer
2k views

Diagnosing low disk space error from PostgreSQL despite low disk usage

I have a Django web application using a PostgreSQL 9.3 database, which occassionally throws the error: File "/usr/local/my_site/.env/lib/python2.7/site-packages/django/db/utils.py", line 94, in ...
user avatar
  • 3,440
0 votes
0 answers
176 views

Table partitions in different tablespaces

I created a "master table" in one tablespace, then a partition in the same tablespace and a 2nd partition in another tablespace created in a mounted NFS share. The master table is called ...
user avatar
5 votes
1 answer
7k views

Using PGPASSWORD variable does not seem to work any more on Postgresql 9.3

In Posgresql you can set a variable called PGPASSWORD (and PGUSER) so you don't have to use password when using postgresql commands such as psql or pg_dump But I am a bit confused because I can't ...
user avatar
  • 829
1 vote
1 answer
237 views

What is postgres-9.4-postgis-2.1

What is postgres-9.4-postgis-2.1 ? what is the difference of postgres-9.4-postgis-2.1 and postgis sudo apt-get install postgres-9.4-postgis-2.1 and sudo apt-get install postgis which one enable ...
user avatar
1 vote
3 answers
995 views

httpd.service Cannot connect to database Centos 7

I'm trying to connect to PostgreSQL Unix domain socket from a python web application with mod_wsgi. Relevant system components: CentOS 7 x64 Python 2.7.5 SELinux disabled PostgreSQL is listening on ...
user avatar
  • 21
0 votes
1 answer
2k 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 ...
user avatar
3 votes
1 answer
6k 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. root@...
user avatar
  • 248
4 votes
1 answer
7k views

pg_basebackup automatic password

I have a master and slave database setup. The master database is on a secure network and only the postgres port is allowed through to the slave database server. The database needs to be secured and ...
user avatar
  • 195
1 vote
0 answers
4k views

How to upgrade from Postgres 9.1 to 9.3 allowing read access during upgrade

"PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit" is working in Debian 6.0 Squeeze It contains 12 databases accessed by 100 users from internet. ...
user avatar
  • 169
0 votes
1 answer
2k views

How to install Postgres 9.3 parallel in Debian Squeeze

Debian 6 contains Postgres 9.1 installation installed from Debian backports in 5432 port How to install Postgres 9.3 also on this server. I found instructions in http://www.postgresql.org/download/...
user avatar
  • 169
3 votes
1 answer
2k views

Postgresql 9.3 Log Shipping on a Hot Standby

My setup I've just set up streaming replication in postgres for the first time (9.3.5), and while the streaming is working as I expect, I'm struggling to get my standby to run the archive_command so ...
user avatar
24 votes
1 answer
12k views

Django: CONN_MAX_AGE persists connections, but doesn't reuse them with PostgreSQL

I've got a django setup are using Django 1.6.7 and Postgres 9.3 on Ubuntu 14.04 LTS. At any given time, the site gets about ~250 simultaneous connections to the PostgreSQL database, which is a Quad ...
user avatar
  • 783
0 votes
1 answer
193 views

Corosync and Pacemaker deployment

I'm currently working on a deployment architecture for a Postgres HA 1 Master/ 1 Slave scenario. After reading lots and lots of documentation I've decided to start using Pacemaker in conjunction with ...
user avatar
0 votes
0 answers
94 views

PostgreSQL replicate data have different time

I'm notice that when I replicate data between 2 server with different time zone, the time data in PostgreSQL is shifted when I load it to a client (in my case, a Rails console). I thought all ...
user avatar
1 vote
1 answer
3k views

Can't read files into postgres

We've just set up a postgres 9.3 server on a Windows 7 machine. If we try to copy data into a database from C:\dbfeeds\csv.csv we get the following error: ERROR: could not open file "C:\dbfeeds\csv....
user avatar
  • 195
0 votes
1 answer
1k views

iptables configuration on Windows Azure (CentOS 6.5) for endpoint load-balanced set

I created 2 VMs (CentOS6.5) on Windows Azure for Postgresql database and HA cluster, everything works fine except when I set iptables service on, the endpoint load-balanced set is down. for security ...
user avatar
2 votes
2 answers
3k views

Postgres SSPI authentication on Windows

I'm trying to enable windows authentication for Postgresql 9.3 (Windows x64 not in domain, UAC is disabled, my account is local admin). The one click installer set the server running under ...
user avatar
16 votes
7 answers
48k views

Wrong version of pg_dump on Ubuntu

I originally installed postgres 9.2 on Ubuntu and later upgraded to 9.3 according to the instructions here: http://www.postgresql.org/download/linux/ubuntu/ (using the postgres apt repository). ...
user avatar
  • 361
0 votes
0 answers
55 views

Postgres 9.3 on Linux - Resource utilization - Multiple vs one service services

I'm consolidating multiple Linux boxes running Postgres into one box. Given the way Postgres handles resource utilization, would one single server service handling all the databases provide a much ...
user avatar
12 votes
2 answers
58k views

Why can't user login on Postgres

I have attempted to set up a read-only user in Postgres, but they are unable to log on. I am unsure the next step to take to solve the problem. When I try and log on as user XXXX I get an error - ...
user avatar
  • 5,909