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
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 ...
3
votes
1answer
919 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
193 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
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
115 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 ...
0
votes
1answer
376 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 ...
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 ...
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
640 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
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?
0
votes
0answers
495 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
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
4answers
909 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
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
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
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 ...
0
votes
1answer
175 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
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: ...
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
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
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 ...