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
2answers
1k views

Accessing Internal Server from Outside through SSH

The issue is as follows: I am using Ubuntu Linux. I am working from home, and I need to access a PostgreSQL database severer within my company's network. Call the DB server X. For security reasons, ...
4
votes
2answers
5k views

How can I create a database in PostgreSQL on Windows 7?

I use Windows 7 on my own home computer. I have installed PostgreSQL and now I would like to create an database. I tried with createdb mydatabase but I got this error message: createdb: could not ...
2
votes
3answers
1k views

PostgreSQL Admin Tool for mac os X

I'm looking for desktop admin tool similar to phpPgAdmin for POstgreSQL in Mac os X . Any recomendation?
0
votes
2answers
3k views

How to change psql default listening host?

I've installed postgresql 8.3 manually on ubuntu 10.10, using ./configure, make and make install. It works perfect but when I try to connect it using psql I need to type following cmd, psql --port ...
0
votes
0answers
496 views

PostgreSQL hangs regardless of which command I execute

The title pretty much sums it up. I'm running PostgreSQL 9.0.0 and am running a database that's using PostGIS. In more detail, the table that I'm having issues with is a monster. The table names have ...
0
votes
1answer
424 views

PHP / Postgre Problem on Mac

Hey there, I'm on a project that uses drupal and postgresql, and i was developing using console and ssh, but i had some troubles and i want to make it local. So i enabled mac's Apache and PHP, and ...
-1
votes
1answer
2k views

Restoring postgreSQL backup to MySQL

How to restore postgreSQL backup file to MySQL server? I don't have postgreSQL server on my system. I have only MySQL server
2
votes
3answers
1k views

Superuser rights on postgres

How do I get superuser rights on postgres. I am among sudoers in Linux, but I don't have rights to create users in postgres. How can I gain superuser rights in postgres? This is my pg_hba.conf: # ...
1
vote
1answer
394 views

Prevent PostgreSQL to start when Mac OS X boots

I installed PostgreSQL 8.4.4 in Mac OS X. I am pretty happy and I don't want to uninstall it since I do occasional development on it. But I would definitely like to prevent OS X to run it every time ...
1
vote
1answer
576 views

change the UI lang when using postgresql psql.exe

I have a PostgreSQL 8.4 database, installed with Japanese as the main language. I am connecting from an English Windows 7 client using psql.exe. Is there any way to change the UI of the messages shown ...
0
votes
1answer
547 views

Person hacked server using postgres user account - What kind of access would this person have?

someone hacked one of my servers using postgres user account. what I do not know is: what is this users home folder? where would bash_history be?
6
votes
2answers
13k views

postgres ident authentication failed

I'm trying to set up django on a fresh Ubuntu VM. I'm following the tutorials along until I get to this: psycopg2.OperationalError: FATAL: Ident authentication failed for user "postgres" The ...
1
vote
2answers
707 views

How can I install Postgres GUI in Fedora 10?

On my server I have Postgres 8.4, but there is no GUI included, so I need to install one. Is that possible? How is it done?
1
vote
0answers
447 views

Can't view database structure via pgAdmin, while psql works ok

I have a PostgreSQL database. I can connect to it via psql no problem, however, when I do database listing: my_database=>\l there is no my_database in the list! When I connect to this same ...
0
votes
1answer
855 views

Where does Cygwin setup.exe keep PostgreSQL?

Basically I just chose to install PostgreSQL from the Cygwin Setup.exe. The process went fine so I reckon it is installed successfully. I found several links to this question like this one However, ...
0
votes
2answers
2k views

How do I uninstall postgres on Mac OS? Can't kill data

I'd like to uninstall postgres on Mac OS 10.6 and start again with a completely fresh installation and empty databases. I've killed all running postgres processes and tried to delete the postgres ...
1
vote
1answer
2k views

How do I uninstall postgres on Mac OS? [duplicate]

Possible Duplicate: How do I uninstall postgres on Mac OS? Can’t kill data I'd like to uninstall postgres on Mac OS 10.6 and start again with a completely fresh installation and empty ...
2
votes
2answers
763 views

Help installing postgres in ubuntu

I'm trying to install postgresql in the latest ubunutu, and I'm following these instructions. When I sudo -u postgres psql postgres I get this error: could not change directory to "/home/james" I'd ...
1
vote
1answer
641 views

How do I give MacPorts privileges?

I tried to install PostgreSQL server development libraries using MacPorts and got the following: Warning: MacPorts running without privileges. You may be unable to complete certain actions (e.g. ...
0
votes
1answer
177 views

How do I create a postgresql user and database from a fresh install?

I just installed postgresql onto an ubuntu box. How can I create user foo with password bar and database baz, so that foo owns baz? foo is not a unix user.
1
vote
3answers
715 views

Postgresql by network

I have running PostgreSQL sever on 192.168.0.102:5432. postgresql.conf has this line: listen_addresses = '*' and pg_hba.conf has this one: host all all 127.0.0.1/32 ...
1
vote
2answers
6k views

Problem with security settings during OSX start up

I recently installed PostgreSQL and am now getting these errors when I start up: “/Library/StartupItems/HWPortDetect” has not been started because it does not have the proper security settings. ...
2
votes
1answer
217 views

Windows based Apache/PHP/Perl/database stacks

Does anyone know if XAMPP's Perl also provides Tk support? Does anyone know of a similar stack which provides PostresSQL in addition to/instead of MySQL? I'd like this to run on Win 7 and XP. Edit: ...
2
votes
1answer
597 views

secure PostgreSQL installation

I want to install postgresql on my computer in such a way that no computer other than mine can see or access it. I'm installing this on my work computer to store some GIS data, I don't want to worry ...
3
votes
1answer
4k views

How to make PostgreSQL start at boot time in Ubuntu?

Every time I boot my computer, I need to start Posgtres manually via sudo /etc/init.d/postgresql-8.4 start It was an easy task to make it start automatically with Init in place: just add a symlink ...
7
votes
4answers
494 views

I'm managing SQLite, MySQL and PostgreSQL databases and want a tool for this locally

I develop web applications on Mac OSX in SQLite, MySQL and PostgreSQL and these are then put on the webserver. I want to be able to take the brunt out of looking at the terminal locally when dealing ...
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, ...
0
votes
2answers
1k views

Where can I find postgresql-8.4-postgis.deb? [closed]

I want the deb package.
1
vote
1answer
3k views

XAMPP with PostgreSQL

I'm looking for a package like XAMPP, but instead of MySQL it would use PostgreSQL. I've done some searching and haven't turned up anything other than doing a full server setup of both.
2
votes
1answer
704 views

Kaspersky blocks PostgreSQL 8.4.1 installation

I was just installing PostgreSQL 4.1 with Drupal and other tools. While the Setup was installing phpWiki.exe, Kaspersky blocked the Setup and quarantined two files: phpWiki.exe, and StackBuilder.exe ...
0
votes
1answer
1k views

postgresql 8.4 original config files (ubuntu)

Where can I find the original postgresql 8.4 config files for ubuntu (/etc/postgresql/8.4/main/*)? Upgraded ubuntu to version 9.10. which included upgrading postgresql from 8.3 to 8.4 dir with ...
0
votes
4answers
910 views

OpenX : mySql VS PostgreSQL

I have been using OpenX's AdServer with mySql as a backend, and since OpenX allows one to choose between mysql and postgres, I was wondering if anyone ever used Postgres and wished to talk about their ...