Hot answers tagged postgresql
The short version You can safely install the PostgreSQL package from the backports. You'll probably get a stable piece of software that will not nuke your system. The longer version Debian comes in three flavours: stable, testing and unstable. See Debian Releases. You are apparently running Debian stable, which is the preferred release for a production ...
apt-get will upgrade to the packages available in the repository from the source that apt is configured to use. The postgresql-9.1 package is version 9.1.4 in the squeeze-backports repository. Add the following to /etc/apt/sources.list.d/backports.sources.list deb http://backports.debian.org/debian-backports squeeze-backports main contrib non-free Then ...
It would appear that you have your your syntax a bit backwards. rc.d usage: rc.d action daemon ... e.g: rc.d list rc.d help rc.d start sshd gpm So you would want to do rc.d start postgresql The rc.d script is simply for convenience. It makes starting multiple ...
Edit your PATH so that /usr/pgsql-9.1/bin/ (the newer one) comes before /usr/bin/. A less package-manager-safe safe alternative is to move/remove/rename the psql in /usr/bin/ and create a symlink in /usr/bin/ to the new one (not tested): > cd /usr/bin # move the old one however you like > ln -s /usr/pgsql-9.1/bin/psql .
Add this to your sources.list: deb http://ftp.de.debian.org/debian/ wheezy main non-free contrib deb-src http://ftp.de.debian.org/debian/ wheezy main non-free contrib Make sure you use the appropriate mirror for your location. Run aptitude update or apt-get update and finish the installation. The interactive mode of aptitude is quite useful to solve ...
Like the comments in this answer suggest, just edit the file /etc/shadow as root (e.g. run sudo nano /etc/shadow in a terminal) and replace the hashed password in postgres's line with *. (If you don't have that line or that file, it'd be interesting to know which Linux distribution and nsswitch settings you use.)
Alternatively, to avoid symlinks, and to avoid changing your $PATH, you could add your command to the hash table: hash -p /usr/pgsql-9.1/bin/psql psql This will put your command into the command hash table and it will be executed before any other command (in fact, no path search will be performed). If you used a command called psql before, then it ...
Your reason for Debian is a good one. But in the future your should stay on that choice. Another idea might be using RedHat, CentOS or Scientific Linux. I found a quite stable looking repository for EL5.
The pl/R list would probably be a better place to ask if you get stuck. Joe Conway also answers questions there. From a quick compile of the pl/R Debian package, it seems like you want to pass a DESTDIR argument to make. Something like make DESTDIR=/home/... Here is the make line from the Debian package USE_PGXS=1 ...
Only top voted, non community-wiki answers of a minimum length are eligible