0
votes
0answers
16 views

Changing kernel.shmmax and kernel.shmmal on ubuntu?

We have an Ubuntu server with 6GB of RAM. We are trying to install Postgres but it is advising us to increase the values for kernel.shmmax and kernel.shmmal. The server is solely a Postgres DB ...
-2
votes
0answers
26 views

postgresql does not start after reboot ubuntu [on hold]

I have just rebooted my ubuntu server, and now I can't get postgresql service working: sudo /etc/init.d/postgresql start * Starting PostgreSQL 9.1 database server * The PostgreSQL server failed to ...
0
votes
1answer
38 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
0answers
22 views

Downgrade to postgis 1.5 and postgresql-9.2 on Ubuntu 13.10

I am having a hard time after having my Ubuntu upgraded. The main problem is that I have a postgis enabled database since postgresql 8.4. I have always updated the OS and databases, as soon as the ...
0
votes
1answer
43 views

Different technologies for syncing with server

Well, I'm currently teaching DB in a course in University. Students had already gone through advanced programming (this includes torturing them through a whole semester with massive projects, they ...
1
vote
1answer
133 views

Munin Postgres plugins: DBD::Pg not found

I'm trying to activate some of the Postgresql plugins for Munin. When I run munin-node-configure --suggest | grep postgres I get the following output: postgres_bgwriter | no | no [DBD::Pg ...
0
votes
1answer
72 views

postgres stopped - how to restart?

my postgresql (9.3.4) was running on Ubuntu, and suddenly stopped tonight. When I try to stop it, logged in as postgres, I get ~$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop; pg_ctl: ...
0
votes
2answers
135 views

PostgreSQL fails to start — no clear reason

I have a server which was happily running PostgreSQL, until a crash this morning. Trying to restart Postgres, but it fails: sudo /etc/init.d/postgresql start Starting PostgreSQL 9.1 database ...
1
vote
2answers
590 views

I have multiple PostgreSQL servers installed. How do I disable auto boot for older server?

I'm running Ubuntu 12.04 on Oracle VirtualBox. A couple months ago, I installed PostgreSQL server version 9.1 on my machine. Just recently, I learned that PostgreSQL server 9.3 supports JSON data ...
0
votes
1answer
113 views

trying to install postgresql-contrib for pg 8.4 in Ubuntu 12.10

I had to do some strange voodoo last year sometime to get postgresql 8.4 installed on a relatively modern ubuntu OS. I had to use 8.4 because the production site is 8.4 and we needed to ensure ...
1
vote
3answers
139 views

Completely reset PostgreSQL to default?

Question Is there a way to completely reset a PostgreSQL installation on Linux, so it is in the same state as when I installed it? Idea I have considered rm -rf /var/lib/pgsql/* rm -rf ...
3
votes
1answer
382 views

Tuning Postgresql on a 16GB Linode VPS

I'm running a dedicated PostgreSQL on a 16GB Linode (Ubuntu 12.04 32bit). I've tried using pgtune, but I'll run into shared memory errors. I.e. The PostgreSQL server failed to start. Please check the ...
0
votes
1answer
737 views

How to completly remove postgresql from Ubuntu 13.04

I've tried sudo apt-get purge postgresql sudo apt-get autoremove postgresql and sudo apt-get --purge remove postgresql But after this dpkg -l | grep postgres gives me that: pi postgresql-9.1 ...
-1
votes
1answer
225 views

Update 9.3.x minor verison of postgres on Ubuntu 12.04?

What do I need to do to update Postgres to a new minor version? i.e. 9.3.1 to 9.3.2? All the documentation gives is stop the server and install the new binaries. I need more detailed information on ...
4
votes
1answer
2k views

Postgresql 9.3 installation fails

I'm trying to install postgresql 9.3 in my ubuntu lucid machine. The problem is that I'm getting this error when running apt-get install postgresql-9.3 => apt-get install postgresql-9.3 Reading ...
0
votes
1answer
73 views

How can I change the Postgres data_directory folder location?

I use Ubuntu 12.04, postgresql 9,1 postgis 1.5. I want to change database location. I use instruction http://www.whiteboardcoder.com/2012/04/change-postgres-datadirectory-folder.html The only ...
0
votes
1answer
145 views

Postgres fails to start, pg_clog fails

Recently one of the machines running Postgres ran out of disk space. After deleting some trashes (not related in any way to postgres!) I've rebooted the system, and - after that - Postgres refuses to ...
1
vote
0answers
359 views

postgres not starting after reboot on ubuntu

I'm not familiar with ubuntu (raring), so could someone help me please: I'm using postgresql 9.1 from apt. It installed the appropriate init script in /etc/init.d/postgresql. I can start the server ...
2
votes
1answer
44 views

Proper postgres port forwarding on linux/ubuntu inside AWS VPC

At Amazon AWS we have VPC, where one node has public IP and others - private. Instance with public IP is something like balancer. On every node we have Ubuntu LTS. One of the private nodes is ...
0
votes
0answers
168 views

postgres server won't start

I get this error when I try to start postgresql: Use of uninitialized value $logsize in numeric gt (>) at /usr/bin/pg_ctlcluster line 235. Line 235 in /usr/bin/pg_ctlcluster last if ...
0
votes
2answers
315 views

Difference of postgreSQL's “trust” and “ident”?

In postgreSQL's /var/lib/pgsql/data/pg_hba.conf trust and ident can be set as method e.g. like so. # TYPE DATABASE USER CIDR-ADDRESS METHOD local all postgres ...
2
votes
2answers
5k views

installing postgres on ubuntu package not available

I'm setting up a VPS with Ruby and Postgres. On my local machine, I have postgresql 9.2.3 (client and server) installed and therefore wanted to install the same on my VPS. Following the instructions ...
0
votes
0answers
133 views

Cannot connect to Postgres from remote address

I cannot connect from my machine to a server running Postgres. I think I've configured it all correctly. No firewall are present on the server. I'm running Postgres 9.1.9 on Ubuntu 12.04 LTS This is ...
0
votes
1answer
315 views

Understanding postgreSQL's indent, md5, password in pg_hba.conf

If I have the following in my pg_hba.conf # TYPE DATABASE USER CIDR-ADDRESS METHOD local all all trust local all all ...
0
votes
1answer
69 views

Linux server responds to postgresql querys and ssh only when pinging the server

I have a problem. My developers are using one of my local servers that is located in our office. The server is running PostgreSQL and when they try to make a query to it, it just lags and then gives ...
1
vote
0answers
198 views

segmentation fault trying to start ldap

My PDC using Samba 3.6 with LDAP (the latest version) works very fine as long as I use hdb as the backend. Nevertheless, I change the backend to sql I receive the following error while trying to ...
-1
votes
2answers
1k views

PostgreSQL server failed to start: request for a shared memory segment exceeded your kernel's SHMMAX parameter

I increased PostgreSQL's shared buffer (among other settings) to 4096M and now PostgreSQL fails to start, giving the error message below. Should I change the kernel's SHMMAX parameter to 4096M? The ...
1
vote
1answer
66 views

How to apt-get install a package for Ubuntu Quantal from Ubuntu Precise 12.04

On Ubuntu Precise 12.04, the package osm2pgsql is currently at 0.70.5+r25090-2ubuntu2. However I need to install a newer version 0.80 but apt-get update does not provide the newer version. Question: ...
0
votes
2answers
2k views

pgAdmin cannot connect to PostgreSQL 9.1

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM. The host's port 5432 forwards to VM's port 5432. pgAdmin Error: Error connecting to the ...
1
vote
1answer
1k views

Postgresql 9.2 “invalid locale name” on Ubuntu 12.04

Today I installed Postgresql 9.2 on Ubuntu precise via apt.postgresql.org – all was relatively painless until I got stuck in a "invalid locale name: it_IT.utf8" error: root@ubuntu:/tmp# sudo -u ...
0
votes
1answer
57 views

Postgresql does not launch [closed]

I just installed postgresql 9.1 on my ubuntu server precise I installed postgres on an ubuntu workstation before and despite following the same steps (documented) nothing works. When i do : sudo ...
0
votes
0answers
151 views

Postgres segfault on Ubuntu 12.04 64

i have a unbelivable problem: Ubuntu server 12.04 64 bit running on Wmware Infrastructure, postgres 9.2 and django connecting via psycopg. Randomly postgres crashes with segfault, si i restart it an ...
0
votes
2answers
528 views

Cannot upgrade PostgreSQL on Ubuntu

When I run apt-get upgrade, I get the following error : dpkg: dependency problems prevent configuration of postgresql-9.1: postgresql-client-9.1 (9.1.7-0ubuntu12.04) breaks postgresql-9.1 (<< ...
1
vote
1answer
413 views

postgreSQL replication and failover with repmgr on Ubuntu

I'm new to Linux and have been tasked with setting up a redundant Linux DB server with PostgreSQL. preferably the fail-over needs to be automatic, but a manual process will be fine for now. What I ...
-3
votes
1answer
98 views

Postgresql 9.1 on ubuntu 9.10

I have a quick question. Did you install postgresql 9.1 on the ubuntu server 9.10 ? If yes, it was a pure installation or update from 8.4 ? If update how did it go ? Where did you get deb package ? ...
0
votes
3answers
685 views

Postgresql - Error: Could not create log file /var/log/postgresql/…

Every time I try to start postgresql, I get this error: * Starting PostgreSQL 9.2 database server * Error: Could not create log file ...
0
votes
1answer
320 views

Recover Redmine Installation on Ubuntu

I am getting crazy with something and I would like some help if there is someone can help. I had an Ubuntu Server where I was running the Redmine Project Management application; and some days ago the ...
1
vote
1answer
122 views

Postgresql init.d script not working

I installed Postgresql 8.4 on my VPS with Ubuntu 10.04. Default setup, nothing unusual. After the installation the dbserver is automatically started and is running great. The installer also sets a ...
0
votes
1answer
602 views

Dependency issue installing libpq-dev on Ubuntu 11.10

I'm trying to install libpq-dev (PostgreSQL library) on Ubuntu 11.10. When I run apt-get I get the following: The following packages have unmet dependencies. libpq-dev : Depends: libkrb5-dev but it ...
0
votes
1answer
285 views

Upgraded to Ubuntu 12.04 from 10.04 and have to transfer database from Postgresql 8.4 to 9.1

I upgraded a server with a Rails application to Ubuntu 12.04 from 10.04 and cannot connect to Postgresql database now... Here is the error message from Rails app: could not connect to server: No ...
4
votes
5answers
694 views

Ubuntu server has slow performance

I have a custom built Ubuntu 11.04 server with a 6 disk software RAID 10 primary drive. On it I'm primarily running a PostgreSQL and a few other utilities that stream data from the web. I often find ...
2
votes
1answer
1k views

Configuration Tuning for PostgreSQL 9.1 PostGIS 1.5 Ubuntu 12.04 Server

My server performance is poor. At times SSH, top, and other features or commands are very slow to respond, taking several seconds or more. A query that normally takes 5 minutes can sometimes take 30 ...
1
vote
1answer
217 views

Gearman persistent queue not saved in Postgres

I have a problem with Gearman 0.32 (ppa:gearman-developers/ppa)- it doesn't save queue in Postgres for queue persistence. Gearman is running, I can add jobs (example with DEBUG verbosity on pastebin ...
0
votes
1answer
2k views

Strange permission errors in new PostgreSQL installation

A freshly installed PostgreSQL (with configuration overwritten) won't start: $ sudo service postgresql start * Starting PostgreSQL 9.1 database server * Error: could not read ...
0
votes
2answers
2k views

I think I have multiple postgresql servers installed, how do I identify and delete the 'extra' ones?

I seem to have a few installations of postgresql on my machine somehow. I'm not sure if this is a mistake or, if Ubuntu for some odd reason duplicates direcotories and keeps them elsewhere. I have a ...
1
vote
1answer
2k views

Empty error on starting almost-default PostgreSQL

When trying to start PostgreSQL, I get this 'empty' error message: root@mountain-lion:/home/ubuntu# service postgresql start * Starting PostgreSQL 9.1 database server * Error: could not exec ...
-2
votes
1answer
376 views

Many Postgresql process. how to handle them?

I'm trying to fix an already install openNMS system on ubuntu. Currently I'm facing issue with postgresql. I stop server using this commnad: service postgresql -$PGVERSION stop after that when i ...
0
votes
1answer
2k views

PostgreSQL 9.1 on Ubuntu Lucid fails to start - how to debug?

I'm using Vagrant with Chef Solo to setup a Lucid 64 box. I'm using a Chef recipe to install PostgreSQL 9.1 from Martin Pitt's backports. The install goes ok until the point where the database is ...
2
votes
5answers
5k views

Postgres used in Ubuntu 12.04

I am trying to get django running on an ubuntu 12.04 release using postgres (clean install). To get it running it used to be that you would have to edit the /etc/postgresql/9.1/main/pg_hba.conf file. ...
5
votes
2answers
3k views

Unable to connect to Postgres on Vagrant Box - Connection refused?

First off, I'm new to Vagrant and Postgres. I created my Vagrant instance using http://files.vagrantup.com/lucid32.box without any trouble. I am able to run vagrant up and vagrant ssh without ...