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
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 ...
-1
votes
0answers
16 views

How do I give postgres more memory to increase performance (on windows)

I would like to increase performance by giving the postgres service more resources (more RAM). How do I do that? (either editing config and restarting or I also have pgAdmin III installed). context ...
1
vote
0answers
88 views

Can not connect to pgAdmin server

I installed PostgreSQL on Windows 10 and the server appears to be in Task Manager. However, I get this error when opening pgAdmin4: Failed to connect to the pgAdmin application server. Click here to ...
1
vote
3answers
2k views

Postgresql connection refused

I'm trying to remotely connect to my postgresql database. I have two virtual machines set up both running ubuntu 14.04. I am trying to connect to the second vm using the first vm using psql -h 10.0....
3
votes
3answers
19k views

Setting up PostgreSQL gives error sudo: initdb: command not found

Step 1: I installed PostgreSQL using sudo apt-get install postgresql-9.1 as recommended on the PostgreSQL website Step 2: I tried to run postgres. It's not found. For whatever reason, the install ...
0
votes
0answers
18 views

Restart of MacOS 10.11.5 Resulted in python modules, R, and Gnuplot and PostgreSQL commands not being executable

I had my iMac hard reset and after it restarted my PostgreSQL changed to an other database service (I have two services) and all the tables are empty and several python modules are not importable, R ...
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 ~]# ...
0
votes
1answer
7k views

Creating user with password or changing password doesn't work in PostgresQL

I'm trying to create a new user role or change existing one's password to be able to work locally with PostgresQL. I'm working on Ubuntu. I can modify the attributes of an user, but for some reason ...
0
votes
0answers
6 views

Specify schema from the Linux CLI when running script with psql

There's a lot of information out already on how to choose the schema and import a script from the psql CLI, but I have a use-case where it would be more advantageous for me to be able to choose the ...
0
votes
2answers
286 views

Can I tell if crashplan has backed up a particular file in a particular state?

I would like to be able to tell, programmatically, if CrashPlan has backed-up a particular file, including the current updates to that file. I.e., that the current contents of a file are backed up. ...
2
votes
1answer
226 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, ...
0
votes
0answers
37 views

postgresql duplicate WAL archive file after successful database restore

On a test machine, I have set up a postgresql cluster (version 9.3) with WAL archiving according to https://www.postgresql.org/docs/9.3/static/continuous-archiving.html. In order to test the recovery ...
2
votes
2answers
3k views

Homebrew postgres won't start after uninstall, reinstall and reboot

I uninstalled and reinstalled postgresql via homebrew. It worked fine until I restarted my computer. Now I'm trying to run my tests and they're blowing up. I'm looking at the current processes and I ...
0
votes
1answer
9 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
1answer
19 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
45 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 TCP/...
0
votes
2answers
133 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
80 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: C:\>psql....
1
vote
1answer
82 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 ...
29
votes
5answers
30k 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
9k 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. ...
0
votes
1answer
35 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
72 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
940 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
40 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
45 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
20k 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
22 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
203 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.1)...
0
votes
0answers
37 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
89 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
12 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
45 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
33 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
82 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
321 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
155 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
50 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
51 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
84 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 well....
1
vote
0answers
19 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
19 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
441 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
160 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 ...