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
vote
1answer
24 views

Is pg_ident.conf working?

When i'm trying to run psql, is says: psql --version psql (PostgreSQL) 9.3.12 psql psql: FATAL: Peer authentication failed for user "testuser" Here is my pg_hba.conf: # Database administrative ...
-1
votes
0answers
12 views

VPN connect to Postgres DB error

I have a big trouble: I need connect to my db in another city with Navicat (or other SQL clients). I made vpn - tunnel, but when I connect (with Navicat or other SQL clients) I get the following error ...
0
votes
1answer
19 views

VM Snapshot Reliability?

Quick question about snapshot backups. I have a hobby project at home where I have a webapp connected to a postgresdb on a VM. I want a simple way to do backups so I wrote a script which stops the ...
0
votes
0answers
26 views

Postgresql not connecting to anything such as msf and armitage

I'm currently running Kali Linux and all of the sudden postgresql has stopped connecting to things. my output for msfconsole is Is the server running on host "localhost" (::1) and accepting ...
0
votes
0answers
33 views

Pg_clogs are deleted after successful pg_upgrade

When starting the new DB After successful pg_upgrade procedure, it deletes all pg_clogs and can't start. Procedure: Install new postgres on machine 'A' pg_upgrade(postgresql 9.0>9.3) - upgrade was ...
0
votes
0answers
27 views

“Navicat for PostgreSQL” gives error “80070003: PrectServer2 not connected” when attempting to autocomplete with materialized views

For some reason I get the error "gives error "80070003: PrectServer2 not connected" when Navicat tries to autocomplete. Take the following example select co.| from visualize.co_mention co When the ...
0
votes
0answers
15 views

Test run crashes OS

This sometimes happens on Windows 10 when I'm running NUnit tests which use postgresql from ReSharper test runner. The test doesn't finish and I see a very strange behavior in all applications. ...
0
votes
0answers
10 views

“Credential agnostic” dump of a (offline) PostgreSQL database?

So, first of all, what I mean by "offline" is that I can ensure that at a given time, and as long as the dump is in progress, no DDL/DML operation will occur on this database. I am no seasoned ...
0
votes
0answers
20 views

Encoding issue with JIRA Trac Importer

while using the JIRA Trac Importer I have a problem with special characters (in my case they are mainly german umlauts.) The problem already occurs in the postgres db in table 'jiraissue': table ...
0
votes
1answer
67 views

pgcrypto extension is installed but its functions are not available

On clients server I had a problem - I did not have permissions to create extension pgcrypto. So server admin did it for me, and now I can see in pg_available_extensions that pgcrypto is installed ...
1
vote
1answer
43 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
14 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
74 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
36 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 ...
1
vote
0answers
22 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
48 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
206 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
91 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 ...
0
votes
0answers
37 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 ...
0
votes
0answers
61 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 ...
0
votes
1answer
44 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 ...
1
vote
0answers
18 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 ...
1
vote
1answer
17 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
238 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
107 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
25 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
223 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
15 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
158 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
2k 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
1answer
197 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
1answer
141 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 ...
0
votes
2answers
106 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?
0
votes
2answers
2k 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 ...
1
vote
1answer
45 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
177 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
175 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
147 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 ...
2
votes
1answer
35 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? ...
1
vote
0answers
38 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 ...
1
vote
0answers
43 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 ...
2
votes
0answers
97 views

I'm trying to install PostgreSQL onto Ubuntu 14.04, but I am having difficulties after following a guide

I originally followed the guide at http://www.postgresql.org/docs/9.2/static/runtime.html. It instructed me to install postgres-xc, which is meant for making clusters of databases. On other sites, I ...
0
votes
1answer
66 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
28 views

How to connect psql to the forumdb.py(a python file) in ubuntu?

I have my system with UbuntuOS installed. I am following an online course where it indicates the use of Vagrant and connects your Windows/Mac system using the Virtual Box having Linux installed in it. ...
0
votes
0answers
42 views

I can't loign as postgres user

I have recently done a backup using Time Machine, shifting the data from a Mac mini to a Macbook pro. In this process I lost the possibility to access to postgres with my user. I can see the user on ...
0
votes
1answer
172 views

How do I host the PostgreSQL server locally? It won't let me run as SuperUser, and it won't let me log out of SuperUser

I've spent all day working on a Database project to try and teach myself how to use SQL and PHP. When I finally went to go and try to host it, the command prompt kept closing really quickly. I took a ...
0
votes
2answers
224 views

Postfix not connecting to postgres pool with local ip address

I have a postfix e-mail server that is contacting a database to query and verify e-mail addresses etc. It connects using pgbouncer to cycle through connections, however my problem was that the ...
0
votes
1answer
163 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
655 views

Can't install libpq-dev on debian wheezy

I already have deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main in my /etc/apt/sources.list file. I have tried to follow the dependency trail but I have reached a dead end. This is how ...