![]() It is fairly safe to copy over the pg_hba.conf file from your backup (using e.g cp /usr/local/pgsqlold/data/pg_hba.conf /usr/local/pgsql/dataīut for the nf file, we would work with the new and cut in changes from the old since new things have been added between 8.2 and 8.3 ConsiderĪnd edit the nf and pg_hba.conf files to your hearts content. 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
0 Comments
Leave a Reply. |