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.
25
questions
0
votes
1
answer
37
views
Data migration between postgresql-9 and postgresql-11 [closed]
What is the best way to migrate postgres-9 database with size of hundreds GB to postgres-11 ? I'm afraid that third party tools will take too long to do this.
0
votes
1
answer
2k
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
1
answer
289
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
1
answer
3k
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:...
3
votes
5
answers
13k
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
1
answer
3k
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
0
answers
192
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 ...
6
votes
2
answers
9k
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 ...
1
vote
1
answer
280
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
3
answers
1k
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
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 ...
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@...
4
votes
1
answer
9k
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
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.
...
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/...
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 ...
25
votes
2
answers
15k
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
1
answer
206
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
0
answers
106
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
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....
0
votes
1
answer
2k
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
2
answers
4k
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 ...
20
votes
8
answers
70k
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
0
answers
66
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 ...
14
votes
2
answers
69k
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 - ...