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