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
2k 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 ...
0
votes
0answers
4 views

SquirrelSQL does not display schema owned by another user (Postgres)

I've noticed that SquirrelSQL (v3.6) does not display schemas in a Postgres (v9.2) database if it is owned by another user, even if I'm connected to the database on superuser. When I do alter schema ...
-2
votes
0answers
12 views

User roles like WordPress [on hold]

We are creating a new CMS for managing content for a school using scala and postgre. How do I create/ manage user roles like admin/teacher/parent/ student? As of now, when we register on CMS, we ...
1
vote
1answer
2k 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
0answers
10 views

Cannot connect to Postgres 9.3 outside of network

I'm trying to remotely connect to my postgresql database. I can connect remotely within my network but when i try to access it from outside the network I receive the error: Could not connect to ...
0
votes
2answers
3k 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 ...
-1
votes
0answers
11 views

Postgresql can't install on Deepin Linux

A six months ago I installed Deepin linux on my laptop, and I've been using it to my daily work. By default I have same configurations that when I used Ubuntu or ElementaryOS, JVM 1.7, MariaDB, ...
1
vote
1answer
75 views

database statistics and reporting with or without parsing of built in logs

I prefer a generic statistical utility / plugin / application, but don't limit myself as specific might do well too. I want to see a way by which I can see query statistics for ALL queries. e.g ...
0
votes
0answers
9 views

Rails Server Not Serving Correctly

Having some issues actually serving my rails app, the server seems to run fine, and I'm incurring no permission errors, or even port bound already errors, nothing at all, but yet the app does not ...
0
votes
1answer
3k 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
1answer
648 views

Simplest import of pipe-delimited text w/header to PostgreSQL

I am trying to create a database with several tables. One of the tables is intended to hold about 1.3 million rows of data from the U.S. Economic Census. The data is in a pipe-delimited text file. ...
0
votes
1answer
34 views

Connect to PgSQL, DROP existent DB, recreate it using CREATE and run some queries alone and from files using Bash script

I need some advice creating a script for help me with repetitive task I do all the time on a development environment. I've a PostgreSQL server and since I'm developing a web application I need to ...
2
votes
3answers
7k 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 ...
2
votes
3answers
2k views

How do I install the Postgres command-line client (psql) on OS X using MacPorts?

I'm trying to install the Posgtres command-line client (typically psql on Linux). I've got postgres installed through MacPorts (postgresql90 and postgresql90-server) but still don't see the client ...
1
vote
1answer
36 views

Make phppgAdmin accessible on Apache/Windows 7

I have my custom stack folder located here... C:\MEDIA\INTERNET\WAPP\ I have Apache located here... C:\MEDIA\INTERNET\WAPP\Apache 2.4\ I have PostgreSQL located here... ...
0
votes
1answer
16 views

PostgreSQL BitRock Installer Hangs

While installing PostgreSQL the BitRock installer hangs when it reaches the point that it should copy the files. There were very few things that came up on search engines for Windows 7, I tried netsh ...
0
votes
0answers
20 views

Why am I getting “FATAL: Ident authentication failed for user ”root“” after changing rails server to port 81

I was running my rails app on the default port of 3000. I opened port 300 with: sudo iptables -A OUTPUT -o eth0 -p tcp --sport 3000 -m state --state ESTABLISHED -j ACCEPT and sudo iptables -A ...
0
votes
1answer
37 views

How to compare databases?

I tried using meld on two dumps from two different databases from the same RDBMS, but it seems that those dumps are not comparable because not being canonical. I tried both pg_dump ... (standard) and ...
0
votes
1answer
235 views

PostgreSQL 9.3 denying remote connection from user despite pg_hba.conf/postgresql.conf configurations

I am running PostgreSQL 9.3 on ubuntu 14.04 LTS. It is the stock Postgres distribution available in apt. I found a bunch of threads in various forums that indicate that the correct way to allow remote ...
1
vote
0answers
20 views

Postgresql: How do full_page_writes help prevent data loss?

From the postgresql docs [full page writes are] needed because a page write that is in process during an operating system crash might be only partially completed, leading to an on-disk page that ...
2
votes
0answers
98 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
17 views

Debian - Postgresql can't install /etc/postgresql after purge

While trying to install DAVICAL on debian wheezy (7.5) I faced a problem and had to purge the postgresql package that is a davical requirement, and then tried to install it again. The installation ...
1
vote
1answer
14 views

How do I know if my Postgres table is clustered?

I have some tables in my Postgres database, and I have set the tables to cluster about an index. But I forget when was the last time I ran cluster maintenance on these tables, and I do not want to ...
0
votes
1answer
65 views

How to get crontab to run when backup requires a password

I am running a script to backup my postgres database on Debian. I am basically running exactly this: https://wiki.postgresql.org/wiki/Automated_Backup_on_Linux Now I have everything working fine when ...
0
votes
1answer
37 views

tsvector type does not exist in Postgres 8.2.15 - how to fix?

I've been working on setting up a Greenplum DB with the server VM at https://network.pivotal.io/products/pivotal-gpdb This VM runs Greenplum on Postgres 8.2.15. I need to set up a text search ...
0
votes
1answer
120 views

Metasploit wouldn't work with the database

I am running Arch Linux on my i386 laptop. I've made a fresh install of ruby1.9 and metasploit from AUR and now I'm experiencing some weird stuff with it. First, it does not load any modules upon ...
1
vote
3answers
2k 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
0answers
144 views

Trouble installing PostgreSQL via npm on Windows 8

I've installed PostgreSQL on my (Windows 8) computer via the binary installer but it's a dependency for something I'm making so I want to install it via the command line to the project's directory. ...
0
votes
1answer
149 views

postgres creating new user/role

I am following this tutorial, and being logged in as postgres I run: createuser --interactive provided name and choosen superuser then: createdb dogspot but when trying sudo -i -u dogspot I get: ...
0
votes
1answer
38 views

Delete PostgreSQL data and Library directories on Mac

I want to completely clean PostgreSQL off of my Mac. I ran the uninstaller and that removed everything but the data and Library directories. I want to get rid of these two directories as well, but ...
0
votes
1answer
354 views

Watch folder and import into database

I am trying to set up a system that whenever a new file is created in a folder it will automatically read the content and push it in a database. These files will mainly be .txt files but I might have ...
1
vote
2answers
76 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 ...
0
votes
0answers
144 views

Postgresql 8.4 service not starting windows 7

Hi All i am not able to start Postgresql service from service manager in windows-7. Error 1053: The service did not respond to the start or control request in a timely fashion although pg_ctl is ...
0
votes
2answers
730 views

Installing PostgresSQL on CentOS 6.4 without yum

I've got a company server running CentOS 6.4 on which I'm required to install the tools required for a webapp deployment. One of those tools is PostgreSQL server, however the company VPN is blocking ...
1
vote
0answers
175 views

Questions on compiling homebrew php with postgres support on Mavericks

I recently upgraded to Mavericks on my MacBook Pro and a few things broke in the process. One of these was the ability to load a drupal page that sits on a postgres database. I get this message on a ...
0
votes
1answer
72 views

Copying File From One User To Another

So I have this file stored in my account. It's postgres dump. To be able to use postgres it seems that I have to execute the following command. sudo su - postgres Once I do this I am now working as ...
0
votes
1answer
169 views

How do I configure Postgresql on Windows 8.1 to connect to Golang?

I'm trying to follow the tutorial here: https://gophercasts.io/lessons/4-postgres-basics but I'm having problems with the way in which the user is set up in Windows 8.1 (64-bit). The tutorial has a ...
0
votes
1answer
21 views

Check the contents of a PostgreSQL data directory

I have found an old unlabeled backup of mine with a PostgreSQL data directory in it. Is it possible to check its contents somehow, without installing PostgreSQL itself?
-2
votes
1answer
422 views

Error installing postgres on Windows 8

I am using a Windows 8 laptop as my dev server. I am trying to install postgres on my laptop, but I get the following error: Problem running post-install step. Installation may not complete ...
1
vote
0answers
147 views

iptables configuration on Windows Azure (CentOS 6.5) for endpoint load-balanced set

I created 2 VMs (CentOS6.5) on Windows Azure for Postgresql database and HA cluster, everything works fine except when I set iptables service on, the endpoint load-balanced set is down. for security ...
0
votes
1answer
111 views

Is there a way to test Postgresql connection from VMware Fusion on a Mac?

I have some reasons to believe that VMware Fusion is not connecting to my postgresql database hosted on my Mac OS. Is there a way to test this connection from my Windows portion through VMware?
1
vote
1answer
2k 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 ...
0
votes
0answers
50 views

PostgreSQL service password is reset after each Windows update

Daminion Server (the server based photo management software) installation insludes the PostgreSQL installation. All is Ok after installing the both Daminion and PostgreSQL services. However after ...
0
votes
1answer
28 views

Is there a tool to manipulate pg_hba.conf programmatically (if not what comes closest)? [closed]

I'm looking for anything above the level of programmatic file manipulation, a command or a python library. There seems to be no alternative to editing the file (assuming that ...
0
votes
1answer
32 views

How to create a database from psql user (not linux user)

I' ve studied some PostgreSQL. In the principle i' ve been teach to create a postgress's user with same name of my linux's user. Now i want to try to make an application, and for this reason i would ...
0
votes
1answer
162 views

Transactions per second in a database (say PostgreSQL)

I refer to 2 documentation pages on PostgreSQL's site: #1 and #2. From these, we see the transaction log is flushed to disk 5 times per second (wal_writer_delay = 200ms), and we also see the RDBMS ...
0
votes
1answer
672 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
213 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 the error message: Error. There has been an error. Unable to write inside TEMP environment variable path. ...
0
votes
1answer
106 views

Postgresql starup script for second instance?

I need to run my second postgresql instance when linux boots. I added this command (like in postgresql documentation) in rc.local: /usr/lib/postgresql/9.1/bin/pg_ctl start -l logfile -D ...
1
vote
0answers
426 views

Installing and running two postgresql versions on different ports (or two instances of same server)

I have postgresql 9.1 installed on my machine (Ubuntu). I need another postgresql server that would run next to the old one. Exact version does not matter, but I'm thinking of using 9.2 version. How ...