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

Load on PostgreSQL, separate between schemas

I'm running PostgreSQL 9.6. I have 2 different schemas: cars.* and logs.*. Whenever I run big queries on log.* it stalls queries in cars.*. Shouldn't this be separated, if there is enough memory in ...
0
votes
1answer
144 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 ...
0
votes
1answer
34 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 ...
0
votes
1answer
558 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:...
1
vote
4answers
6k 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 ...
3
votes
1answer
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 ...
0
votes
0answers
167 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 ...
3
votes
1answer
4k 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 ...
0
votes
1answer
210 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 ...
1
vote
3answers
821 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 ...
0
votes
1answer
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 ...
3
votes
1answer
5k 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@...
3
votes
1answer
4k 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 ...
1
vote
0answers
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. ...
0
votes
1answer
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/...
3
votes
1answer
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 ...
17
votes
1answer
8k 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 ...
0
votes
1answer
187 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 ...
0
votes
0answers
89 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 ...
1
vote
1answer
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....
0
votes
1answer
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 ...
2
votes
2answers
2k 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 ...
6
votes
6answers
26k 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). ...
0
votes
0answers
48 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 ...
8
votes
2answers
35k 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 - ...