PostgreSQL is a community developed, open source, relational database, made available under a BSD-like license. The PostgreSQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

-1
votes
2answers
5k views

ubuntu 13,10 “Failed to download repository information”

I have ubuntu 13.10- 64 bit version on my machine.recently i tried to install postgres for ROR development but i couldn't complete the postgres installation and found that my update manager always ...
0
votes
2answers
6k views

How can I remove Postgres completely from my Mac?

I have been experiencing spooky behavior with Postgres after using the Mac installer for Postgres. There seems to be an existing half-baked Postgres installation that was already there and remains ...
0
votes
1answer
6k views

Oracle11g localhost:1158/em not connect

In my Windows 7 professional edition, I installed Oracle Database Express Edition 11g Release 2 which is downloaded from Oracle.com. The SID is 'orcl', username is 'system'. When I attempt connect to ...
16
votes
4answers
22k views

“FATAL: lock file ”postmaster.pid“ already exists”

I just reinstalled postgres via brew install postgres I ran initdb /usr/local/var/postgres -E utf8 but got this: The files belonging to this database system will be owned by user "atal421". This ...
1
vote
0answers
15 views

Run shell and check port of specific postgresql version in ubuntu

Several versions of postgresql (9.3, 9.4 and 9.5) on a server with different ports and I want to start the shell of a specific one. If I run the shell: psql It returns: psql (9.5.0, server 9.3.10) ...
0
votes
0answers
11 views

how to create backup form PostgreSQL without console postgresql?

I have a VPS (ubuntu base). I can not access to console of postgresql. How should I backup from PostgreSQL? Thanks.
0
votes
0answers
59 views

New PostgreSQL Slave server ERROR - Timeline

I've started a new SLAVE PostgreSQL server set up. master: 192.168.100.1 slave1: 192.168.100.2 slave2(NEW SLAVE) 192.168.100.3 * NOTE: I run the pg_basebackup from another STANDBY SERVER. Not ...
0
votes
0answers
10 views

Compile PGModuler from source on ArchLinux

I am following the wiki article on installing pgmoduler. For some reason the config path for my pqlib is not set correctly. The output is: $pkg-config libpq --cflags --libs >-lpq They provide a ...
0
votes
0answers
17 views

trying to connect ami with another ami postgresql

i have php 5.6.14, apache2, moodle 3.0 (server 1) | postgreSql 9.3 (server 2) but I have already set this error moodle. Error: database driver problem detected The site administrator ...
12
votes
3answers
11k views

Prevent Postgresql from running at startup

At some point in the past, I had installed posgresql and I can't get rid of it: $ ps -A|egrep postg 232 ?? 287 ?? 0:00.02 postgres: logger process ...
1
vote
0answers
13 views

how to copy postgresql gitlab database via FTP on ubuntu

Hi I would like to copy my old database of gitlab to a new server but my old server is working only as FTP server. Can I copy the old gitlab database to a new server via ftp ?
0
votes
1answer
32 views

Incremental database/table backup using pg_dump on CentOS7

I've googled how to take incremental backups (weekly or daily) using pg_dump on CentOS7. Some suggest WAL instead. Can incremental backups be done with pg_dump? I'm currently using pg_dump to back ...
1
vote
2answers
81 views

I do not know how to install Npgsql version 3.0.3

I want to install Power Pivot and Power Qwery in Excel for Postgresql. I installed Visual Studio and I installed Npgsql in Visual Studio PM (Package Manager Console). I can see, in Power Qwery ...
0
votes
0answers
29 views

pg_restore from directory format

I did pg_dump with directory format(-fd), but now I can't restore it. Restore command: ./pg_restore -U x -d x -fd -j 10 /.dump_directory/ Error: pg_restore: [archiver (db)] connection to ...
1
vote
0answers
27 views

Settings for a fast pg_restore

I used the tips link, for making faster pg_restore. But I am afraid that after PITR changes(last tip about wal and archive), my replication will not work. Can someone say for sure, if after restore ...
1
vote
4answers
16k views

Default password for postgreSQL

What is the default password for the "postgres" user when I install postgreSQL on Windows? I googled for "postgres default password" but it doesn't return any immediate result.
0
votes
1answer
27 views

How can I add a flag in PostgreSQL source code that works in both frontend and backend?

I'm trying to do some changes to postgresql source code. I want to add a flag that works in both frontend and backend. Here is what I have done so far. 1- I created my header file mine.h in which I ...
0
votes
0answers
36 views

Squid reverse proxy, DMZ, how to forward any non-http request

I'm actually facing an issue with some network-protocol related problem. I have my own domain, a owned DMZ, and externals users. In my DMZ, I have a reverse proxy who handle HTTP connection very ...
1
vote
0answers
13 views

Postgres files taking up lots of space

I have nearly 40G of files on my OSX, all under the following path : /usr/local/var/postgres/base/9466989 36G total 1.0G 10107638.6 1.0G 10107638.5 1.0G 10107638.4 1.0G 10107638.3 1.0G ...
0
votes
1answer
2k views

Failing to start Postgres SQL Server on Centos

I just followed this tutorial: http://www.unixmen.com/postgresql-9-4-released-install-centos-7/ But I can't start my postgres sserver on my centOS 6.5 machine. Here's the error: [root@vm5 ~]# ...
1
vote
1answer
15 views

Why does my Postgres users have execute permission on a table?

I log in as a PostgreSQL superuser using psql, and issue a \dp, and the output contains the following line: public | account | table | someuser=arwdx/someuser+| If I ...
1
vote
2answers
106 views

Postgres restoring replication, timeline conflict

I have a postgres database (version 9.4) with streaming replication (master, slave configuration). Lets call master db A and slave db B. The server running A failed and we had to do a switchover, ...
0
votes
1answer
52 views

Could not connect remotely to Postgre SQL on Microsoft Azure Virtual Machine

I have a Microsot Azure Virtual Machine running Ubuntu 14 LTS. I installed Postgres SQL and I need to allow remote login. I believe I already configured everything fine. But still when accessing ...
0
votes
0answers
24 views

Why is user _postgres on os x unable to write in a 0777 mode directory?

I'm trying to create a function in Postgresql, written in plpython, to move files from one directory to another in the file system, and optionally create the destination folder if it doesn't exist. ...
0
votes
0answers
157 views

Owncloud with Postgress error

(Hope I'm at the right place now, Server Fault wasn't apparantly...) I'm trying to set up Owncloud (recent version) with a PostgreSQL (9.1) database on Bananian (Debian 7). Owncloud is able to ...
0
votes
0answers
14 views

How can I delete Postgresql without using the terminal?

It doesn't work on my mac, and I tried to find a uninstall folder, but I didn't found it, which is probably because I installed Postgresql through the terminal.
0
votes
0answers
93 views

Opening the Postgresql port

I'm trying to connect to a Postgresql server from a remote computer using: psql -U dbuser -h [host address] But I get the following error: psql: could not connect to server: No route to host Is ...
-1
votes
1answer
465 views

Posgres Could not translate hostname

I am attempting to start a Postgresql server, but get the following error when I run the command: pg_ctl start Error: LOG: could not translate host name "146.232.222.*", service "5432" to ...
0
votes
2answers
624 views

How to start only one version of PostgreSQL database, in this case 9.1?

I have installed PostgreSQL 8.4 and 9.1 on same Ubuntu machine and I want to try to run only 9.1 and 8.4 to stay off. When I run /etc/init.d/postgresql start it starts both. How to start only one ...
0
votes
2answers
1k views

Connect to PostgreSQL database from Excel 2013 Power Query with Npgsql

I want to pull data from a PostgreSQL database on my local network with Power Query. By default my version of Excel lists three options under the "Get External Data/From Database" menu on the Power ...
0
votes
2answers
85 views

How to move postgresql database from one computer to another?

I've been created an Internet service on Debian server. I want to move all data from one server to a new one. So, how can I move the postresql database? What is the best pipeline?
1
vote
1answer
1k views

Postgresql query within a bash script

We are having an issue with a postgresql bash query. The output of the query from the bash script add's additional quotes around the date. Please can you help me fix it?! Script: #!/bin/sh ...
1
vote
1answer
4k views

Setting up postgresql server connection with pgadmin3 fails with Exception

I have installed postgresql database on Fedora 17. When I create a new server connection through pgadmin3, I get this Error in a popup window: postgresql The server doesn't accept the current ...
0
votes
1answer
112 views

postgresql 9.1 raspberry pi could not bind IPv4 socket

when I started my working sinatra app on my Raspberry pi rev 1 machine running wheezy with the latest apt-get upgrade a few weeks ago I find that my postgresql 9.1 server is no longer running. Hunting ...
4
votes
1answer
5k views

Postgresql has broken apt-get on Ubuntu

On ubuntu 12.04, whenever I try to install a package using apt-get I'm greeted by: The following packages have unmet dependencies: postgresql-9.1 : Depends: postgresql-client-9.1 but it is not going ...
2
votes
1answer
15k views

NOQUEUE: reject: Relay access denied

I recently setup a mail server following the instructions on linode.com (https://library.linode.com/email/postfix/postfix2.9.6-dovecot2.0.19-mysql) except I am using postgreSQL instead of mySQL. ...
0
votes
1answer
153 views

Can not find script file prerun_checks.vbs when installing postgresql 9.4.4 on Windows x64

I am getting the following error in the bitrock_installer log when I try to install postgresql (postgresql-9.4.4-3-windows x64): Script output: Input Error: Can not find script file ...
0
votes
0answers
362 views

Problems installing postgresql-9.3.4-4-windows-64 on Windows 7

I am trying to install postgresql-9.3.4-4-windows-64 on Windows 7 x64 and keep getting this error message: Error. There has been an error. Unable to write inside TEMP environment variable ...
3
votes
1answer
9k views

How do I start Postgres on CentOS 6.5?

Whenever I try to start Postgres, it gives me an error. Even if I remove the directory it complains about, it still fails. [root@ip-172-31-15-65 init.d]# service postgresql start /var/lib/pgsql/data ...
4
votes
2answers
3k views

How can I use UTF-8 on Linux from Windows 7 via PuTTY?

I use PuTTY on Windows 7 to access a Linux machine with Ubuntu 10.10. I think that Windows 7 is using Latin-1. But I need to use UTF-8 on the Linux machine and in a PostgreSQL database. How can I do ...
1
vote
1answer
44 views

NAS suitable for this situation?

I work from home and am considering getting a NAS. Would using a NAS be suitable for my situation: I alternate working from a desktop and laptop, both of which run Linux I use PostgreSQL a lot along ...
0
votes
2answers
124 views

Unable to install PosgreSQL on Ubuntu 14.04

I have been trying to install PostgreSQL on my Ubuntu machine. I end up getting this error. postgresql : Depends: postgresql-9.3 but it is not going to be installed postgresql-contrib : Depends: ...
1
vote
1answer
124 views

PgAdmin III writes files with junk in them, which causes PSQL to fail

I encountered the dilemma of needing to run some psql console commands because a colleague needed to use psql's \i directive in a saved script to execute additional SQL-statements from another file, ...
1
vote
0answers
116 views

Cannot configure PostgresSQL extension for php in Cpanel

I have a Centos 6.6 x86_64 vps cloud server with WHM and cpanel. It contains easyapache installed in it and working fine. php sites are working fine with it. I have installed PostgresSQL 9.3 in the ...
1
vote
2answers
1k views

Change postgreSQL database user from windows user in CMD

i recently installed PostgreSQL on windows 7, each time i try to use CMD to execute SQL command, i get this error createdb: could not connect to database template1: FATAL: password authentication ...
2
votes
1answer
34 views

Is the order of columns significant in a Postgresql Primary key definition?

Postgresql allows you to define a primary key using a group of columns instead of one if desired, like so: PRIMARY KEY(a_id, b_id) But is the order of the columns in this definition significant? ...
0
votes
1answer
55 views

Remove PostgreSQL database files

I've uninstalled PostgreSQL some time ago, but now I needed it again, and installed it. When running rcpostgresql I get the following: /usr/sbin/rcpostgresql Your database files were created by ...
0
votes
0answers
33 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
148 views

Snorby with PostgreSQL installation issue in Mac OS X 10.10.2 (Yosemite)

Trying to setup Snorby for Snort with PostgreSQL on Mac OS X 10.10.2 (Yosemite) Snort 2.9.7.2 GRE (Build 177) PostgreSQL 9.4.1 ruby 1.9.3p551 (2014-11-13 revision 48407) [x86_64-darwin14.1.0] ...
1
vote
0answers
41 views

Permission denied trying to setup postgres sql

I'm trying to setup Dspace for a uni job here, but this Protgres SQL is asking for a password (For the postgres user) but it's supposed to be indent, I have no idea what's going on. So, When I try to ...