On EL its /var/lib/pgsql/data so you may want to init there although why The default location of new install is different for each system. We tend to like PostgreSQL in the /usr/local/pgsql/data folder since thats where we are used to finding it.For 8.3.5+ you need to add the item in red to also install the server. Note the install file - should look something like.Select the appropriate repository config file for your OS and choose 8.3 from here and navigating thru:.Your YUM update from getting postgresql from other sources For extra good measure rename the old folder with and backup the nf and pga_hba.conf to a safe location.usr/local/pgsql/bin/pg_ctl stop -D /usr/local/pgsql/data You may also want to download the backup if its really important to you and in case you screw up the server usr/local/pgsql/bin/pg_dumpall –U postgres postgresqlserverdbs.sql The first thing you want to do if you care about your data is to back it up with commands similar to the below. If you are running a prior version of PostgreSQL, most likely it was installed in the /usr/local/pgsql/ folder. 64bit will generally have an 圆4 and 32-bit will have i386 and/or i686 (for intel based).Īlso gives details of the version you are running If this returns something with el4 (then you are running Enterprise Linux 4), el5 (Enterprise Linux 5), centos (ELsmp).

Determine which version of Linux you are running with the following commands:.For windows users, you can use Putty which we covered in PuTTY for SSH Tunneling to PostgreSQL Server

Postgresql yum repo