The postgresql tag has no wiki summary.
6
votes
3answers
133 views
Choosing Linux Distro for PostgreSQL
I'll begin by saying I'm a newbie sys admin.
I need a new PostgreSQL 9.1 machine. My go to distro is Debian (for no good reason other than it's what I first learned). However, when I started ...
0
votes
0answers
30 views
Clean install of Postgress - should I remove files manually?
I'm doing a clean install of Postgres 9.1 using Homebrew on Mac OSX. Following a Homebrew tutorial, I manually deleted most of the files of the previous install.
However, when I run locate psql | ...
1
vote
2answers
32 views
Find all postgresql and mysql databases on a system
Is there a way to find all postgresql and mysql databases on my system? (Perhaps using the find command).
0
votes
1answer
55 views
Postgres 9.0 linux command to windows command conversion [closed]
i am working on an application using delphi 7 as the front end and postgres 9.0 as the back end.
I have to upload images to the server so i use \lo_import and \lo_export for inserting images on the ...
6
votes
3answers
145 views
How can I build and install PL/R as a non-privileged user?
There is a postgres instance, and I have the ability to build my own instance.
Using these instructions I ran:
USE_PGXS=1 make
which worked but then
USE_PGXS=1 make install
did not, with this ...
1
vote
1answer
73 views
PostgreSQL on FreeBSD - 'Kerberos 5 authentication not supported'
I've been trying to get a FreeBSD machine to talk to a networked postgreSQL database. I assumed that the machine had kerberos installed, as it's what I use to log in, and I was told that FreeBSD has ...
1
vote
0answers
146 views
“No PostgreSQL user name specified” - possible concurrency issues? (xpost from SO)
posted this on StackOverflow, and someone suggested I try here as well... Not entirely sure it's the right place, but it's worth a shot.
For my dissertation I'm running the same cronjob on around 300 ...
0
votes
0answers
51 views
Wrong pg_config
I compiled postgres manually and pq_config shows wrong directories ie shows:
PGXS = /usr/lib/postgresql/9.1/lib/pgxs/src/makefiles/pgxs.mk
instead:
PGXS = ...
2
votes
1answer
159 views
/etc/rc.d/postgres start vs rc.d postgres start
What's the difference between those two commands?
/etc/rc.d/postgres start
and
rc.d postgres start
Aren't those interchangeable?
I tried starting PostgreSQL using the latter, but it only works ...
