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

3
votes
2answers
1k views

PostgreSQL - syntax error

What is wrong with the following statement? GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO foo; I get this error ERROR: syntax error at or near "ALL" LINE 2: ON ALL TABLES ...
0
votes
1answer
2k views

How can I get a mysqldump file encoded in utf-8 for psql?

I am migrating some data from a MySql database (v5.1.44/MyISAM/collation=latin1_swedish_ci) to a PostgreSQL (v9.0.4/the one included in OSX Lion). I'm using $ mysqldump --compatible=postgresql > ...
1
vote
1answer
5k views

Trouble installing PostgreSQL 9 64bit on fairly fresh Windows 7 Pro 64bit [closed]

The installation proceeds most of the way without any issues. At the end, I get an alert saying that there was a "Problem running post-install step. Installation may not complete correctly. The ...
1
vote
1answer
92 views

How can I build an old application for 64bit?

I am trying to build postgresql 7.4.6 on a 64bit machine for 64bit. I'm not sure whether this code is 64bit compatible. Is there a way to check? If it is 64bit compatible, do I need to do anything ...
1
vote
1answer
11k views

How do I restore a plain text postgres .backup file

I exported a postgres db from pgAdmin in a plain format because I wanted to search the whole db text. I then tried to restore the database back but it gives an error saying that the archive file is ...
2
votes
1answer
2k views

Searching a whole postgres db for a string

In phpmyadmin, I can easily search for text in the tables in my databases using the search tab. Was wondering if I can do the same with the postgres installed locally on my computer. I have looked at ...
1
vote
2answers
80 views

How to I change the path when I log in as a new user in ubuntu?

I am running ubuntu on a flash drive. The default log in is "ubuntu". I installed Postgresql and created a new user called "postgres". However, when I switch to postgres with "su postgres", the ...
-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 ...
1
vote
0answers
1k views

Create a “postgres” user account on OSX?

I just made a mistake: I installed PostgreSQL on Mac OSX 10.6.7 and when I wanted to connect to it I did su postgres, then it asked me for a password and I did sudo passwd postgres to change the ...
1
vote
2answers
2k views

Free Database Browser for PostgreSQL?

Does anyone know of a free PostgreSQLdatabase browser that I can use besides RazorSQL since It has a 30 day trial? It would be great to have something similar to the SQlite Database Browser, light ...
1
vote
3answers
765 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 ...
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
1answer
778 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
587 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
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
0
votes
1answer
562 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
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 ...
1
vote
0answers
593 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
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 ...
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
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
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?
1
vote
1answer
630 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
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 ...
0
votes
1answer
389 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
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 ...
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
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, ...
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
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. ...
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?
0
votes
0answers
567 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
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
4answers
919 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
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
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
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 ...
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.
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: ...
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. ...