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.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.

1
vote
1answer
51 views

Poor website performance [duplicate]

Not sure if this is the correct forum to ask my question. 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 ...
0
votes
1answer
198 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
0answers
1k 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 ...
1
vote
1answer
217 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
1answer
534 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
0answers
3k 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
1answer
181 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
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 ...
0
votes
2answers
94 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? ...
4
votes
1answer
31k 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, ...
3
votes
3answers
7k 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
1answer
536 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 ...