PostgreSQL is a community developed, open source, relational database, made available under a BSD-like license. The PostgreSQL documentation is expansive and incredibly useful.
0
votes
0answers
22 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 ...
1
vote
0answers
28 views
installing redis server on an ec2 instance where postgres is installed
I have an ec2 microinstance. I have installed only my postgressql database server over there.
I want to try redis for celery backend and also for some realtime value storing.
I am expecting as of ...
0
votes
0answers
16 views
PHP - adding PostgreSQL (and other) modules doesn't work - debian 6
I try to install nginx + PHP 5 (FastCGI) + PostgreSQL on my Debian 6 VPS and I have a problem with adding new modules, especially pgsql. My phpinfo() shows "PDO drivers: no value" and of course ...
0
votes
1answer
68 views
Data Source not found in Excel (Data/From other sources/From MS Query) connecting to PostgreSQL
I set up an ODBC connection to a datamart with c:\windows\SysWOW64\odbcad32.exe.
I set up my Data Sources in the System DSN tab using the PostgreSQL ANSI driver.
When I go into Excel bring in the ...
1
vote
1answer
59 views
apt-get fails at everything in Ubuntu due to postgresql error - how to fix?
I've got a server with zoneminder, mysql, ffserver and some ffmpeg instances running on it, but for some reason everything seems to be tied to PostgreSQL. I noticed an error when loading the ...
1
vote
1answer
38 views
Access PostgreSQL on Mac without switching users
I've got a Mac running OS X Lion (10.7.5), with PostgreSQL 9.2.4 installed. I've initialized a database cluster and started a server, all as the postgres user. When I try to access certain ...
0
votes
0answers
16 views
Uninstall Postgresql 1.9 from OS X lion
I ended up with two versions of Postgresql. They are in my usr/local folder as pgsql and pgsql-1.9. I guess the first one is the one that comes originally with my computer and the other is the one I ...
0
votes
0answers
29 views
Network goes “Request Timed Out” when I run a query
I use postgreSQL 9.2 as the database and Java 6 as the programming language.
There is no problem when I run my program on the server computer. But when I run my program from a remote client, ...
0
votes
2answers
29 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.
1
vote
1answer
33 views
PostgreSQL installed from source, no pg_config alias
So I installed pgsql 9.0.10 on Ubuntu 12.10 from source (./configure, make, make install). It all went well, created /usr/local/pgsql/ and everything that it should contain, but I have encountered one ...
0
votes
1answer
56 views
where do I put my `pg_hba.conf` file in EnterpriseDB for OS X
I have a pg_hba.conf.sample file, but no pg_hba.conf file. I want to make one and put it in the right place. Where do I put pg_hba.conf?
0
votes
1answer
43 views
Upgrading PostgreSQL via Homebrew
I'm attempting to update PostgreSQL from my system's version (9.1.5) to the latest release (9.2.3). I've followed the directions on this railscast and am encountering issues.
After installing psql ...
0
votes
1answer
46 views
Debian PostgreSQL doesn't appear to be working
I've just set up a server running Debian 6.0 64-bit. I've installed PostgreSQL through aptitude, and now i try to access PostgreSQL without any luck. I am trying to access psql as the user postgres, ...
2
votes
1answer
69 views
PostGreSQL Authentication Failure with “trust” option
I'm trying to setup a PostGIS db using PostGreSQL 9.1 on Ubuntu 12.04. I've set up the database, created a user account "jay" with no password, added spatial functionality following section 2.5 here, ...
0
votes
1answer
51 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 ...
0
votes
1answer
20 views
How to change output pattern in shell?
I run the psql command from a Linux shell. The resulting output looks like a table:
Name Age
-----------------
John 24
But I would like to get the result with commas like ...
0
votes
0answers
64 views
How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?
Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn?
The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
1answer
96 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 ...
3
votes
1answer
85 views
Ubuntu postgresql missing man pages, PGDATA, and critical commands
I installed postgresql as well as postgresql-doc, nevertheless it seems that ubuntu either does not put commands in my path, or if it does put them in my path, it removes the man pages for the ...
0
votes
1answer
190 views
How to install PostgreSQL 9.2 on CentOS 5?
PostgreSQL 9.2 isn't available on CentOS (the latest version is 8.1), so in order to get it, one has to add a postgre repository with the command
rpm -ivh ...
0
votes
1answer
224 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 ...
0
votes
0answers
88 views
Completely remove Postgresql which was installed with Homebrew
A while ago I did brew update, brew upgrade and now things are working kind of funny. When I run cucumber I'm told that
FATAL: database "project_test" does not exist
(PG::Error)
I keep chasing ...
2
votes
1answer
44 views
PostgresSQL created a user account on OSX
Hello I installed PostgresSQL on my macbook but when I restarted my macbook later I saw that instead of the usual User account and the Guest account I now have also a Postgres user in my startup page ...
1
vote
1answer
100 views
Postgresql is not avaible in Libreoffice Base
I want to edit a postgresql base using libreoffice-base.
When I launch the database wizard of Libreoffice-base, I am blocked at the first step: I can select an existing base, but the only ones ...
0
votes
1answer
40 views
Hide some functions from display in PG Admin III
I have installed modules (XML2, UUID) in Postgres.
In PG Admin III, all the functions contained in those modules display under the "Functions" tree.
The list is lengthy, and it slows down my work ...
0
votes
0answers
211 views
PostgreSQL Error Invalid Command \N
I searched for this situation, so I apologize if this has already been posted.
I have PostgreSQL 9.2 running on a Windows Vista machine. I had exported a pg.backup file and then I attempted to ...
0
votes
0answers
54 views
I don't understand how postgres is installed (OSX)
Im still having issues installing postgres and really do not understand all that is going on.
( Postgres could not connect to server: No such file or directory )
I've been using the homebrew ...
0
votes
1answer
87 views
rsync fails under daemon but succeeds when run from terminal
I have script [1] that is executed by Postgres daemon (WAL archiver) and fails with exit code 12; see [2]. But if I execute the same script on a terminal/ssh session, it succeeds; see [3].
User ...
0
votes
2answers
88 views
PhpPgAdmin: Edit contents
How can I edit the contents of a table in phpPgAdmin without using SQL? Or is there an alternative tool that allows me to edit datasets?
0
votes
1answer
265 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 ...
0
votes
0answers
36 views
Postgresql stackbuilder not downloading any packages on Windows XP
This is a weird problem, I am facing. Postgresql Stack Builder doesn't download any packages.
On Mac, Its downloading.! But, on Windows, It gives an alert saying "Failed to open ...
3
votes
3answers
52 views
heredoc prompts not passed in
I'm trying to automate the creation of a PostgreSQL user with a bash script.
I'm specifying the initial password as prompted by the "createuser" command, and I'd like to do it in bash, which I think ...
0
votes
0answers
207 views
Connection to postgresql inside Virtualbox via portforwarding fails
I have a postgresql server inside a virtualbox created by vagrant.
I have also set up a portforwarding from 5432 inside the box to 15432 on the host system via the Vagrant file.
When connecting via ...
1
vote
0answers
39 views
Remove postgres from Mac that is installed in /usr/local/
I want to completely uninstall postgres and start from scratch - the version I have is refusing to work with PostGIS 2.0. I have read other answers on how to do this, but none of them seem to fit the ...
0
votes
0answers
50 views
Remove postgres from Mac - installed in /usr/local/, can I just delete files?
I want to completely uninstall postgres and start from scratch - the version I have is refusing to work with PostGIS 2.0. I have read other answers on how to do this, but none of them seem to fit the ...
0
votes
1answer
33 views
Setting PostgresSQL for my VPS
I am about to deploy my app to a vps for the first time, and running into some issues while configuring my DB.
After running the following commands...
# PostgreSQL
add-apt-repository ...
0
votes
2answers
749 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 ...
1
vote
2answers
116 views
PostgreSQL: Dump consistant state without locking
A good database backup is consistent, so the whole dump represents the state when the dumping was started. A typical strategy for this on MySQL is to lock the table, so no additional data can be ...
-1
votes
2answers
45 views
Torrentflux broke after upgrade
A working torrentflux setup seems to have gone broken after upgrading PHP to 5.3 and Postrgres to 9.2beta3 on a FreeBSD 8.2 server. The login screen will show up fine, but after clicking the login ...
1
vote
1answer
53 views
How to connect or set a specifig schema in LIBGDA database browser?
I've here a PostgreSQL based database, with a schema and some tables inside it. When I use psql I must put the schema name in front of every statement:
SELECT * FROM schemahere.tablehere;
Or is ...
2
votes
1answer
112 views
Too Much Swapping, even though RAM is ~75% Empty
I have a VPS with 9GB RAM, 300GB HDD, 3 GB Swap, 7 Cores.
The OS is CentOS 5.7 Final.
I have postgres9.0 running on my machine, with proper tuning done (at least by book/wiki of PostgreSQL).
What ...
0
votes
2answers
469 views
Postgresql 9.2 where is the initdb located on Ubuntu
I am trying to install postgres on EC2 / EBS.
I am following this article and stuck at the following step.
sudo su -
su postgres -
/usr/pgsql-9.0/bin/initdb -D /pgdata
I cant find the initdb ...
1
vote
1answer
148 views
User permissions for creating PostgreSQL DB
I'm working on Ubuntu. Following is one of my commands.
$ psql -U kuser -d postgres
Then this connects to the database. But from postgres terminal when i try
postgres=> CREATE DATABASE kdb;
...
3
votes
1answer
1k views
Postgresql has broken apt-get on Ubuntu
On ubuntu 12.04, whenever I try to install a package using apt-get I'm greeted by:
The following packages have unmet dependencies:
postgresql-9.1 : Depends: postgresql-client-9.1 but it is not going ...
1
vote
1answer
231 views
Are PostgreSQL's database files binary compatible between Windows, Linux and Mac OS X?
Assuming 64-bit OS editions on each and only one copy of PostgreSQL running at a time, can I host my PostgreSQL database files in Dropbox and expect binary compatibility on all three platforms?
I've ...
0
votes
1answer
290 views
Postgresql fails to start on Ubuntu 10.04.4 LTS
After I install and when restarting Postgresql I get this error. I have tried changing permissions accordingly(the owner of the all the directories and files in the error message is postgres) but to ...
0
votes
1answer
48 views
Alternative location for db file on linux server? [closed]
The postgreSQL database file is stored in quite an obscure location by default:
/var/lib/postgresql/[version]/data/
I was hoping to put it in a more unified place for organisation purposes. I was ...
2
votes
1answer
309 views
(-bash: initdb: command not found) When installing postgres mac
I get the following error (-bash: initdb: command not found) in the terminal when trying to install postgres on my mountain lion mac osx?
Also, does any one have a good resource for installing ...
0
votes
1answer
133 views
List of StopWords in Postgres 9.1
What is the list of stop words (ignored words) used by Postgres when doing fulltext searches? Is there a way I can find this out (by running a query or something)?
So you know what I'm looking for, ...
1
vote
0answers
261 views
Mac OSX Mountain Lion Rails Postgres (wiped out a lot of stuff)
Having trouble with Postgres since I upgraded to Mountain Lion (and now regretting it). Lost hours trying to fix it to no avail.
When running rails server then visiting my app at 0.0.0.0:3000 I get ...
