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

0
votes
1answer
7 views

How can I cache a small table data on a Db side?

Say I have a table Statuses in which the data doesn't change for a long time and there're a few records only. I need to use it often in joins. How can I cache data from it on the Db side, in ...
0
votes
0answers
15 views

What is the best way to create a friendly interface for postgresql database? [closed]

I've created a Posgresql database, and I'd like to create a web form to be easier and faster for inserting data in the database. I found out there are a lot of different alternatives, php, python, ...
0
votes
1answer
17 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
33 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
2answers
119 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
2answers
38 views

pg_restore fails on zlib compressed dump

Created a dump of a postgresql (windows version 9.3 or 9.4) database with the command: C:\>pg_dump -U user -Z 6 database > db.dump restoring it with psql or pg_restore fails: ...
1
vote
1answer
40 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 ...
0
votes
2answers
2k views

PostgreSQL Windows installation failure

I was trying to install PostgreSQL 9.2 in Windows 7. When I launched the installer, it failed and showed the error message: Unable to write inside TEMP environment variable path I did a lot of ...
0
votes
1answer
3k 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 ~]# ...
25
votes
5answers
27k 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
2answers
7k 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 ...
4
votes
3answers
8k views

pgAdmin list of keyboard shortcuts

I've been using pgAdmin for several days and so far I like it. However, I can't find a list of keyboard shortcuts documented anywhere, either on the pgAdmin site, in the help, or in the options menu. ...
-1
votes
1answer
7k views

Oracle11g localhost: 1158/em cannot 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 ...
0
votes
1answer
25 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 ...
3
votes
2answers
4k views

Incremental Backup for PostgreSQL 8.3

I'm looking for a way to make good incremental backups for a large (more than 100 GB) PostgreSQL 8.3 DB. I'm currently using pg_dump which isn't incremental and very slow in backup and restore, ...
1
vote
1answer
53 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) ...
2
votes
1answer
849 views

How to use ShemaSpyGui for view database diagram

I installed Postgre today and I want to watch database shema. I resolvse to use schemaSpy and download it and also schemaSpyGui and then I see: This is the command (password not displayed!) ...
0
votes
0answers
35 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
34 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. ...
1
vote
5answers
19k 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
0answers
15 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
1answer
96 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 ...
0
votes
0answers
31 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 ...
-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
0answers
78 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
39 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
12k 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
24 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
60 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
255 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
116 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
40 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
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 ...
0
votes
0answers
74 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
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
18 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
294 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
124 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
26 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
229 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
198 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
2answers
886 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
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
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
153 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 ...