PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) available for many platforms including Linux, FreeBSD, Solaris, Microsoft Windows and Mac OS X.
-1
votes
0answers
28 views
Not able to Delink the old tables [closed]
When i tried to delink the old tables i'm getting the following error
NOTICE: SELECT COUNT(*) AS count from pg_tables where schemaname='fr' and tablename='check_deny_2013_04_17'
CONTEXT: PL/pgSQL ...
0
votes
1answer
27 views
How to restore the user postgres?
In the second answer in this thread is a warning about changing the UNIX password for "postgres".
I have already changed the password for "postgres".
How could I restore the initially state of the ...
1
vote
0answers
462 views
“No PostgreSQL user name specified” - possible concurrency issues?
For my dissertation I'm running the same cronjob on around 300 machines, which is:
10,25,40,55 * * * * /path/to/db_script.sh 1>/dev/null
This script gets some values from the system (whether ...
1
vote
2answers
122 views
How do I specify which version of a program to run?
Here's my situation: I have two versions of postgres installed, and with the two versions, come two different psql interactive terminals.
One is located at /usr/bin/psql, and starts when I run # ...
3
votes
1answer
135 views
Upgrade Minor Version of Postgres in Debian using apt
I'm trying to move from 9.1.3 to 9.1.4. I thought all I had to do was "apt-get update" and "apt-get upgrade", but that didn't work. It did install some updates, but that was only for 9.1.3. Any ...
2
votes
1answer
246 views
Running a query without the OS cache
I want to emulate a client site who doesn't have much caching because they have so much I/O all the time. I want to run a SQL query on my machine (on my VM to be precise) with the same limitations ...
6
votes
3answers
621 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 ...
1
vote
2answers
74 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
175 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
237 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
176 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 ...
2
votes
1answer
284 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 ...
