PostgreSQL is a powerful, open source object-relational database system.

learn more… | top users | synonyms

0
votes
0answers
12 views

postgresql clusters load balancing using haproxy

can anyone tell that how to configure PostgreSQL clusters for load balancing using ha proxy?
0
votes
1answer
10 views

Best Practise for PostgreSQL Backup

I'm writing a script for backing up PostgreSQL each night and I'm happy with doing a full database dump. I'm curious about how I should backing up though. Is it wise for me to first do a VACUUM and ...
0
votes
1answer
13 views

14.04: How to convert mysql to postgresql?

is there anyway to convert a mysql file (.sql) to a postgresql file? I have a number of tables and creating them all over again in phppgadmin is gonna take a lot of time. Any help will be greatly ...
34
votes
5answers
141k views

How do I find the path to pg_hba.conf from the shell?

I would like to obtain the path to pg_hba.conf from the shell. The path varies between versions of PostgreSQL. For instance, for 8.4 and 9.1: /etc/postgresql/8.4/main/pg_hba.conf /etc/postgresql/9.1/...
0
votes
2answers
60 views

Is it possible to install PostgreSQL 9.6 (Beta) on Ubuntu 14.04?

I'm using repository from postgresql.org and trying to get PostgreSQL 9.6 (beta) for Ubuntu. Just in case, the repository is http://apt.postgresql.org/pub/repos/apt/ references at https://www....
1
vote
0answers
22 views

14.04: Cannot start postgresql service

I got this issue on starting postgresql. It was working fine yesterday. But all of a sudden it cannot connect. I tried to connect to phppgadmin initially and it did not find servers So I thought I ...
-1
votes
0answers
275 views

Could not find rake-11.2.2 in any of the sources Run `bundle install` to install missing gems [closed]

I'm using Kali Linux and after I done apt-get dist-upgrade I keep receiving this ''Could not find rake-11.2.2 in any of the sources Run bundle install to install missing gems. '' When I do ''bundle ...
0
votes
0answers
14 views

Is there any Ubuntu Version that comes with Pre-installed ERP Softwares?

At present I'm working on Openbravo,a web-based ERP business solution for small and medium-sized companies. To work with this, I need to Setup few things. Some are mentioned below. My question is ...
0
votes
0answers
118 views

two postgres have been installed, remove both

I have previously installed postgres 9.1 by How To Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 14.04 It was installed correctly and my app was working fine, but today its not working ...
1
vote
0answers
23 views

/var/run/postgres keeps being deleted, preventing postgres from starting

By default, my PostgreSQL installation was creating a socket in /tmp but my psql command-line client was looking in /var/run/postgresql/.s.PGSQL.5432. To remedy this, I edited postgresql.conf and ...
34
votes
6answers
32k views

What is the difference between “service restart” and “service reload”

I'm trying to understand the difference between service restart [someservice] and service reload [someservice]. I understand that "restart" restarts the service whereas "reload" reloads the ...
1
vote
1answer
9 views

postgresql ignores sysem locale on installation

before installing I'm checking locale: $ locale LANG=en_US.UTF-8 LANGUAGE=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US....
5
votes
4answers
69k views

The following packages have unmet dependencies!

I am writing this because I am very confused about installing postgresql 9.3 on mine Ubuntu 14.04. First I need it for mine Python/Django development, and I ran in to the problem, when i tried to ...
-1
votes
0answers
17 views

connect from ubuntu server to pgsql in windows [closed]

I have a website that is on Ubuntu server but my database is in windows and i have config file too. how can I connect these one together? this my config file : * PostgreSQl : pgsql * MySQL : ...
0
votes
0answers
29 views

Pgadmin3 not working on my ubuntu 15.10

I try to install pgadmin but I get this error when i try to start it: Fatal Error: Mismatch between the program and library build versions detected. The library used 2.8 (no debug,Unicode,compiler ...
0
votes
1answer
491 views

How to install pgAdmin 4 on Ubuntu 16.04

How to install pgAdmin 4 on Ubuntu 16.04 ? Lack of information on homepage. https://www.pgadmin.org/ https://www.postgresql.org/ftp/pgadmin3/pgadmin4/
3
votes
2answers
2k views

Enable PostGIS extension on Ubuntu 14.04.2

I have troubles enabling PostGIS extension on Ubuntu 14.04.2 and PostgreSQL 9.3. I have installed the packages with this step by step procedure. PostgreSQL and pgAdminIII seem to be installed ...
7
votes
3answers
20k views

Install postgresql. Why is initdb unavailable?

I'm following these instructions, however I can only get to step 17.2. Despite installing postgresql successfully via the sudo apt-get install postgresql command, upon running initdb -D /usr/...
0
votes
0answers
70 views

UBUNTU trusty/14.04 - postgres/postgis installation problem

I installed postgresql and postgis using the following command: sudo apt-get install postgresql-9.3-postgis-2.1 but now when I try to create a postgis extension, I get this error: CREATE EXTENSION ...
2
votes
2answers
148 views

Upgrading from 15.10 to 16.04 Configuring Postgresql-Common Issue

I am currently at a loss right now while upgrading from 15.10 to 16.04 in Ubuntu. I currently can't take screen shots because I am right in the middle of the upgrading the distribution and my ...
0
votes
0answers
14 views

apt-get installing postgresql binaries with root ownership

When I was reading an article about installing postgresql from source, it mentions not only to make sure that the data directory is owned by the postgres user, but also the binaries. In fact, it says ...
0
votes
0answers
17 views

Error on Starting PostgreSQL 9.3 database server on UBUNTU 14.04

When I do this command to start PostgreSQL 9.3 Server : sudo service postgresql start I got this error : * Starting PostgreSQL 9.3 database server * Error: Could not create log file /var/log/...
1
vote
1answer
73 views

Unable to connect to PostgreSQL

I had PostgreSQL 9.3 working fine but when I tried to upgrade to 9.5 I began encountering errors. So I purged Postgres from my system following the first answer of this question. Then I installed ...
1
vote
2answers
2k views

apt-get -f install gives error

When I run apt-get -f install, it gives the following error: # apt-get -f install Reading package lists... Done Building dependency tree Reading state information... Done Correcting ...
2
votes
1answer
340 views

Postgresql 8.2 service will not stop and uninstall

My system config is as follows: System (running on Amazon EC2) Ubuntu 10.04 Postgresql-8.2 installed and it is working. ubuntu@ip:~$ sudo /etc/init.d/postgresql-8.2 status: Running clusters: 8....
0
votes
1answer
194 views

After upgrade to 16.04, Postgresql 9.4 is broken

After upgrading, postgresql 9.4 is broken. Any help would be greatly appreciated. The command: # /etc/init.d/postgresql start (04-29 14:52:01) [ ok ] Starting postgresql (via ...
0
votes
1answer
41 views

Unable to import PostgreSQL database in Ubuntu

I need one help i need to import my database file to ubuntu using PostgreSQL.When i am checking my database its looking like below. When i am trying to import my database file using the following ...
14
votes
3answers
25k views

pg_ctl: command not found, what package has this command?

I have installed pgadmin using the ubuntu software center and am trying to access a local database (recently downloaded from the internet). I have tried to run the pg_ctl command (running as postgres) ...
3
votes
1answer
47 views

Landscape - Postgresql database fill up storage

Is there a way to limit database size or to erase landscape events? If not, I suppose that I will have to extend the filesystem ? root@prod-lds-db:~# du -shc /var/lib/postgresql/9.1/main/* 12G /...
-1
votes
2answers
38 views

How to create superuser and importing sql?

i had problem to creating super user with this command sudo -u postgres createuser --superuser wahyu (wahyu is my user name) i've already using root access to do that but i found this [root@...
0
votes
1answer
1k views

How to install postgresql-9.4 on Ubuntu 16.04?

Tried sudo apt-get install postgresql-9.4 but it doesn't find it. How can I install this version?
1
vote
2answers
635 views

Had to upgrade Postgres on Ubuntu; now, how to access old, missing databases?

My local connection on my Ubuntu server (14.04) wasn't working to my Postgres (9.3) database, so I tried upgrading it to 9.4 to solve the connection issues. Luckily I can now connect to the database, ...
0
votes
0answers
11 views

I have installed Quasar and can't get it to open

After downloading Quasar, and installing PostSql (I have both 8.4 and 9.5 installed...), I can't get Quasar to open. There is a icon in the main menu for Quasar Admin and Quasar Accounting, but when ...
9
votes
3answers
20k views

How install postgresql 9.4

After trying apt-get install postgresql-9.4, updating, trying again etc etc. It seems I can't install it: Couldn't find any package by regex 'postgresql-9.4' I know there is a similar question in ...
9
votes
4answers
14k views

install postgres 9.4 on ubuntu 14.04-2 [duplicate]

I need to install postgresql 9.4 server but I only can find version 9.3. wit apt. How can I install or upgrade it?
0
votes
0answers
207 views

msfconsole not running Ignoring bcrypt-3.1.11

I have problems when running metasploit on Ubuntu LTS 14:04. I've created a database msfconsole and run postgresql but still does not work. root@evan:/home/evan# msfconsole Ignoring bcrypt-3.1.11 ...
0
votes
1answer
100 views

Postgis installation on Ubuntu 15.10 server gives dependencies error

I am trying to install Postgis on Ubuntu server 15.10 using the following command: sudo apt-get install postgresql-9.5-postgis-2.2 but I am getting following error: The following packages have ...
0
votes
1answer
28 views

Failed to fetch postgresql problem on Ubuntu 14.04

I am having a problem fetching data from postgresql repository. I have already uninstalled this one. But it keeps showing when I issued a "sudo apt-get update" command.
0
votes
1answer
165 views

How to configure setting of phppgadmin with xampp and postgresql 9.5?

I'm using Ubuntu 14.04, Xampp 5.6 and PostgreSQL-9.5 I have already uncommented these lines: extension=php_pdo_pgsql.dll extension=php_pdo_sqlite.dll extension=php_pgsql.dll but still I this ...
1
vote
1answer
233 views

Pgadmin3 not working on ubuntu 15.10

I installed postgres than pgadmin3 on ubuntu 15.10. install was successful but when I type pgadmin3 in terminal and hit enter I get this following error : Fatal Error: Mismatch between the program ...
0
votes
0answers
12 views

When upgrading PostgreSQL servers, do I have to upgrade the client software on the client machines?

So I have an architecture that looks familiar to anyone who has used AWS before: RDS(PostgreSQL 9.4) PHP clients(laravel 4.2) Nods.js clients The question I have is when I upgrade the RDS do I ...
0
votes
2answers
104 views

Landscape for personal use

I am trying to install Landscape Dedicated Server for personal use on a clean Ubuntu 14.04 server from scratch. After adding the ppa-repository and updating apt, I install the thing with apt install ...
5
votes
2answers
4k views

How to make Postgres start automatically on boot

I am new to Ubuntu and I would like to know how to make postgresql start automatically on boot and how to configure my setup so that I can start the postgres server if need be. I am working on a ...
0
votes
0answers
201 views

sudo apt-get update fails on postgresql

I am trying to install nodejs but it keeps on failing. So I have uninstalled nodejs and found out that sudo apt-get update still fails. It's been so long that I have used postgresql. but here is my ...
0
votes
0answers
51 views

Unable to load pgAdmin3

I am receiving the following error reporting some type of a conflict when I try to load pgAdmin3. What steps do I need to take to resolve this update conflict? rpiggott@rpiggott-HP-G61-Notebook-PC:~$...
0
votes
0answers
63 views

permission issue with commands start with sudo

whenever i run command with sudo it shows following error. how can i fix this ? like i want to clear cache by writing command sudo php bin/console cache:clear it first prompt sudo: /var/lib/sudo ...
18
votes
2answers
32k views

How to fix PostgreSQL installation

I upgraded from Maverick to Natty recently and everything went fine except during the dist-upgrade something went wrong with PostgreSQL. I've since tried reinstalling, removing, and even purging it ...
0
votes
1answer
95 views

Database not starting in init.d

I am attempting to setup a small postgresql database on a beaglebone black. The application is slow so I am storing the database on a 64GB microsd card. I formatted the drive, mounted it all ...
0
votes
1answer
79 views

postgresql install on lubuntu 14.04 -i386

Got a version of Ubuntu (lubuntu-14.04.4-desktop-i386) to install and behave on this HP Pavilion dv5 and was able to install Libre Office via Lubuntu Software Center. Progress. My next task is to ...
9
votes
3answers
9k views

PostgreSQL 9.1 adminpack install

everywhere I see guides for postgre, it seems to be on version 8.4. In that case the instruction is: sudo -u postgres psql < /usr/share/postgresql/8.4/contrib/adminpack.sql that location doesn't ...