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
591 views

Installation on Linux & Win7: Aptana, PostgreSQL, Ruby, JQuery (WWW on Apache)

Basically I have 2 systems, where I want to develop (and use) my application: A Linux (Debian) system. This is my server. Here I have PostgreSQL (& phpPgAdmin), Apache, Ruby. Typically I use ...
2
votes
1answer
485 views

make pgrouting problem

I try to make pgrouting. What am I doing wrong? anton@anton-P4I45Gx-PE:~/src/pgrouting$ cmake -DWITH_TSP=ON -DWITH_DD=ON . -- POSTGRESQL_EXECUTABLE is POSTGRESQL_EXECUTABLE-NOTFOUND -- Found ...
2
votes
1answer
606 views

Services running multiple times?

I've installed a postgres db on my debian squeeze. There's a /etc/init.d/postresql to control the database. When I type pstree -c, I get two traces with postgresql. After /etc/init.d/postgresl stop I ...
2
votes
0answers
379 views

How to copy and paste content from PostGIS psql console in Windows 7?

I just get started with POSTGIS and I am digging through Mannig's POSTGIS in Action. I am using Windows 7, POSTGIS 1.5 and Postgresql 9. Sadly, I am not able to copy and paste anything from my text ...
-1
votes
1answer
2k views

Setting up PostgreSQL on Mac OS 10.6.8 Snow Leopard?

I've installed PostgreSQL 9 on Mac OS. I need to change the configuration so that I can access Postgre with the blank password. Searching online yields lots of solutions for older versions of the ...
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 ...
0
votes
3answers
1k views

Shell script runs only when copying its content to a new shell script file

I have a shell script thats generated by a java jar that I am unable to run anything postgres related when its created. However, when copying all of its content into a new shell script file, I am ...
8
votes
2answers
9k views

Install libpq-dev on Mac OS?

Does anyone know how I can install libpq-dev on Mac OS 10.6? It's a pre-requisite for something else I want to install. There doesn't seem to be a macport for it, so how can I install it on a Mac?
3
votes
1answer
929 views

ubuntu: root password

Well, I don't know exactly how it happened. But, thing is if I issue a command which I need root priviliges an error message comes that says <user> does not have an entry in sudoers file I ...
2
votes
1answer
1k views

How do I restore a Postgres database from file backups

I use Time Machine on my Mac to backup my system. I have just managed to clobber my Postgres database and would like to restore it using my Time Machine backups. The latest changes don't matter, so I ...
2
votes
1answer
200 views

Emacs M-x sql-postgres encryption

Is it possible to encrypt the connection established with M-x sql-postgres in Emacs? If so, how?
0
votes
1answer
118 views

Should I run postgresql all the time?

I'm wondering whether there is any speed (in the OS) or security issues with running postgresql all the time (using launchctl) for development of rails apps, whether I should launch postgres only when ...
2
votes
3answers
270 views

SSH without password doesn't work with user postgres

I've tried manually adding the pub key to authorized_keys and authorized_keys2. I've also double checked the permissions on .ssh (700) and authorized_keys (644). I can login without password on the ...
0
votes
1answer
388 views

How can I give psql a variable instead of an sql file as input?

So I have some sql in a varible. I could put that in a file and give it to psql as input but I wonder if there is an easy way to do this without the file ?
4
votes
1answer
2k views

How can I use UTF-8 on Linux from Windows 7 via PuTTY?

I use PuTTY on Windows 7 to access a Linux machine with Ubuntu 10.10. I think that Windows 7 is using Latin-1. But I need to use UTF-8 on the Linux machine and in a PostgreSQL database. How can I do ...
0
votes
1answer
1k views

Why pg_dump 'trust' authentication fails under root and works under another user?

I have pg_dump command in cron that accesses PostgreSQL under user postgres and does not provide a password. pg_dump --username=postgres ... I have set in pg_hba.conf that user postgres should be ...
10
votes
2answers
8k 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 ...
0
votes
2answers
214 views

Mac with Rails & Postgres Installed - Overheats quickly?

Anyone else have this problem? I'm on a 15" Macbook running rails and postgres. Needless to say, shortly after powering up the mac and getting into development work, the mac gets very hot at the ...
0
votes
3answers
181 views

Postgres configuration

I'm installing PosgreSQL 9.0 over FreeBSD 8.1. In MySQL I have to change the root SQL user's password, here how can I do? And how can I add other SQL users? Thanks.
1
vote
2answers
2k 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
2k 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
564 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
430 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
397 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
628 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
561 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
738 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
463 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
880 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
812 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
650 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
187 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
763 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
220 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
628 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
508 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
710 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 ...