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
0answers
10 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 ...
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
31 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
79 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
27 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 ...
0
votes
0answers
35 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
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 ...
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 ...
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
102 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
51 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
152 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
433 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
151 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
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 ...
0
votes
2answers
84 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
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 ...
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
123 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
115 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
33 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
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 ...
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 ...
2
votes
0answers
92 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
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
26 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
0answers
116 views

How to check database relationships in PostgreSQL?

A guy made a DB design on MS Server 2010 and managed to import the schema to my PostgreSQL database, the thing is we want to check if the existing relationships were imported as well, how do i do ...
0
votes
0answers
54 views

Upgrade Postgres from 9.2.2 to 9.3.6

I have an old server with a Postgres 9.2.2 database. Now I have a new server which has a Postgres 9.3.6 database. I copied the data-directory (/var/lib/pgsql/data) from the old server on the new ...
0
votes
1answer
135 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
179 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
145 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
534 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 ...
1
vote
0answers
82 views

Is there a way to let PostgreSQL restore but not create a new timeline

I'm using PostgreSQL 8.4 and am creating a standby server. Since PostgreSQL 8.4 doesn't have built-in replication support, I did the following things try to get read only access to the standby server, ...
0
votes
0answers
67 views

Revit DBLink fails to import from PostgreSQL ODBC driver

I am trying to export and import back a Revit 2014 model. I am also using PostgreSQL 9.3/9.4 as backend DBMS. I am able to export correctly the Revit model to a database in PostgreSQL but not the ...
0
votes
1answer
438 views

Install Postgresql 9.4 with Puppet

I would like to let Puppet manage Postgresql 9.4 on Ubuntu 14.04.2 LTS. I have install the https://github.com/puppetlabs/puppetlabs-postgresql module and configured it like this for 9.3: class { ...
1
vote
2answers
221 views

ERROR: could not load library “/usr/lib64/pgsql/hstore.so”: /lib64/libc.so.6: version `GLIBC_2.14' not found

I’m trying to enable hstore on my PostgreSQL database running on an Amazon Linux AMI. I’ve already jumped through a ton of hurdles and ended up with this error that I can’t get past: ERROR: could ...
2
votes
1answer
888 views

Make Wine run its applications as user profile, not Administrator

For a very specific case, I need to install PostgreSQL under Wine to run a Windows application that packs it's own installation of PostgreSQL even if PostgreSQL is already installed, for security ...
2
votes
1answer
98 views

Script stops when user is changed

I am trying to create a script that logs as a different user to create a database backup. So far I have encountered a few problems, such as having to input sudo password, or not being able to bypass ...
0
votes
1answer
22 views

CentOS6 Backup fails; “permission denied”

I am currently trying to do a backup of a server and am getting an error message when running my script. The script runs correctly on certain directories, but for the directory I am attempting to use ...
-2
votes
1answer
2k views

OSX: Snort: ERROR: /etc/snort/../rules/local.rules(0) Unable to open rules file “/etc/snort/../rules/local.rules”: No such file or directory

I'm trying to setup and run Snort IDS on mac using this kinda tutorial: https://discussions.apple.com/thread/3370709?start=0&tstart=0 OSX Yosemite (10.10.2); PostgreSQL 9.4.1 (installed with ...