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
3answers
590 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 ...
5
votes
2answers
6k 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
1answer
655 views

Postgres db dump/restore error

I am attempting to dump/restore a database between servers. Here is what I have tried is DUMP: pg_dump -h localhost -U user database > dump.sql Restore Onto other server: createdb -h ...
1
vote
1answer
1k views

Shared memory in chroot environment

I'm playing with Ubuntu 11.10 launched in a chroot environment under Android 3.2.1. Most of the software works fine except PostgreSQL. When installed or initdb launched it's saying: FATAL: could ...
1
vote
1answer
578 views

Using PostgreSQL on Mac OS X Lion

I just got a new Mac with Lion installed on it. I then installed Xcode (4.1 through the App Store). Next, I installed Homebrew and I was about to do brew install postgresql like I had done on Snow ...
-1
votes
2answers
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
0
votes
1answer
475 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?
0
votes
2answers
208 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 ...
1
vote
0answers
513 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
378 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
301 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 ...
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
3answers
986 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 ...
3
votes
1answer
875 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
946 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
180 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?
1
vote
1answer
420 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
114 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
2answers
148 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
333 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
844 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 ...
0
votes
1answer
389 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 ...
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
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, ...
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 ...
1
vote
1answer
613 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. ...
1
vote
2answers
633 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?
0
votes
0answers
376 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 ...
2
votes
1answer
657 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
4answers
891 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 ...
1
vote
1answer
364 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
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.
1
vote
0answers
397 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
777 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 ...
0
votes
1answer
156 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.
2
votes
1answer
210 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: ...
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 ...
1
vote
2answers
5k 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
510 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 ...
0
votes
2answers
1k views
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 ...