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 Please refer to Installing PostgreSQL 9.0 via Yum. NOTE: We have a newer article on Installing PostgreSQL 8.4 with Yum and an even newer one for PostgreSQL 9.0 Person may be new to using Linux in general.
Person has SSH root access to their PostgreSQL box.We are gearing the content of this article to the described user profile This one instead since it seems more up to date than the other. UPDATE - since Devrim's move from Command prompt - he has started a new yum repository. In this article we will go over using the new PostgreSQL YUM repository for Redhat Fedora, Enterprise Linux and CentOS distros that is available at. First we'd like to thank Devrim of Command Prompt for working hard on making this new YUM repository available.
0 kommentar(er)
