Questions tagged [postgresql-9.1]

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

Filter by
Sorted by
Tagged with
11 votes
2 answers
109k views

How to change Postgresql database from Read-only to Writable

I'm new to managing servers, especially postgresql on Ubuntu Server, so bear with me. I'm trying to synchronize between two databases on two different computers, but I'm not sure what I did wrong, ...
0 votes
1 answer
372 views

Postgres Table size & record counts

I want to understand the below result behavior for finding a size for a table with x MB while try to count record in this table but no records found in postgres database db_server=# \dt+ ...
1 vote
1 answer
100 views

Poor website performance [duplicate]

I have a website where the number of visitors is increasing and it is facing a poor response time. I am not a server specialist and for this reason I want to expose my issue here to receive some ...
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 ...
1 vote
1 answer
512 views

Persist statistics data from Postgres' stats_temp_directory on demand

We are investigating I/O load in one of our VMs and possibilities to optimize it and it showed that most of the load is generated by the stats collector of PostgreSQL. It jumps between 3,5 and 6,5 MB/...
0 votes
1 answer
869 views

Unable to backup postgres databse

We have postgres 9.1 running on Ubuntu box. The postgres db size is 155GB and it has about 13200 tables. The Ubuntu box has 120GB RAM. The Ubuntu box is a docker container. When an attempt to backup ...
1 vote
0 answers
2k views

Postgres pg_trgm Extension Creation Error

I have installed Postgres 9.5 in an attempt to install GitLab. As part of the process the trigram extension (pg_trgm) needs to be created on the database. When I issue the create statement I get the ...
4 votes
3 answers
9k views

Unable to locate package postgresql-server-dev-9.1 on Ubuntu 14.04 x64

I am trying to install postgresql-server-dev-9.1 on Ubuntu 14.04 x64. I first did sudo apt-get install postgresql and it worked. I then tried sudo apt-get install postgresql-server-dev-9.1 and i get ...
0 votes
1 answer
943 views

psql: duplicate GSS authentication request

What does it mean by saying 'duplicate' ? How to troubleshoot this? guest@www:~$ klist Ticket cache: FILE:/tmp/krb5cc_1000 Default principal: user/admin@SOHONET Valid starting Expires ...
4 votes
0 answers
6k views

Meaning of postgresql log "using stale statistics instead of current ones because stats collector is not responding"

I have a Postgresql 9.1+134wheezy4 running on Debian 7 Wheezy. From 2015-02-07 on (I guess it has been backported then, see below) I regularly see the following line in /var/log/postgresql/postgresql-...
1 vote
1 answer
458 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
2 answers
110 views

Data Directory PostgreSQL 9.1 to Windows 2008 Server R2

"My predecessor" has installed PostgreSQL 9.1, now I would like to know what is the "Data Directory" installation. Now I am using this interface: Can I know using this interface the Data Directory? ...
0 votes
1 answer
692 views

Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

I want to connect to my local installation of PostgreSQL 9.1 using my machine user (who is vagrant). So, after reading PostgreSQL documentation, I thought I just needed to: Add username map in ...