Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
0answers
3k 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
0answers
155 views

Restore PostgreSQL 9.3 to 9.6

We have a PostgreSQL 9.3 database in a production environment and a 9.6 database in a test environment. I've never used PostgreSQL before and am trying to use the pg_dump and pg_restore tools to back ...
0
votes
0answers
34 views

How to assign previleges on a postgres schema to a user?

pg_hba.conf contains: ... host 10.10.10.10 service_db admin md5 ... Executed the following commands: ###CREATE DB ADMIN sudo -u postgres psql -p 5432 -d postgres -c "CREATE USER 'admin' ENCRYPTED ...
0
votes
0answers
2k views

Can't start postgresql. postgresql.conf contains errors

I have a postresql-9.3 installation which I have been running successful for over a year on a CentOS 6.8 system. While attempting to get phpPgAdmin setup (getting tired of using pgsql for everything) ...
0
votes
0answers
152 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 ...
0
votes
0answers
87 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 ...
0
votes
0answers
45 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 ...