Re: Older version?

Thanks, the upgrade of all packages is in the plans!

Andy

On Sun, 21 Apr 2002, Jean-Michel POURE wrote:

>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This email brought to you courtesy of Jumbo Classifieds.
>
> RECRUITERS: Single Job posts to 4000 employment related web sites $29.95
> Discounts AVAILABLE! http://www.JumboClassifieds.com/pricing.phtml
>
> Open your FREE 30 day trial account with Jumbo Classifieds
> and broadcast your jobs to nearly 4000 employment related web sites!
> http://www.JumboClassifieds.com/signup
>
> JOB SEEKERS: 1000's of FRESH jobs updated around the clock!
> http://www.JumboClassifieds.com
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
>
>
> Le Samedi 20 Avril 2002 19:51, Andy Lewis a écrit :
> > I'm running an older version 7.0 of PostgreSQL and am looking for the
> > compatible version of PgAdmin.
> > Can anyone help me out?
> > Thanks in advance,
>
> Dear Andrew,
>
> pgAdmin1 can be downloaded from CVS. You will need to compile it with Visual
> Basic and register OCX components manually. If you are not a professional
> programmer, you have 1% chances of achieving a manual installation.
>
> Also, it is recommended to use pgAdmin2 / PostgreSQL 7.1.2
> - PostgreSQL 7.1.2 provides many bug-fixes and new features,
> - pgAdmin2 has many improvements (function modification, view modification,
> etc, a better GUI, many bug fixes..).
> - pgAdmin1 and PostgreSQL 7.0 are outdated and not supported by our team. We
> wron't be able to help you in case of problem. Sorry.
>
> By far, it is recommended to upgrade to PostgreSQL 7.2.1 / pgAdmin2. This
> solution provides a much more stable system.
>
> Here are the required steps to migrate database 'foo' :
>
> 1) Dump your database
> Let's suppose your database name is "foo"
> We will backup it to filename : filename.sql
>
> root(at)localhost: pg_dump -u foo > filename.sql
>
> View filename.sql to be sure all your data is there.
> Backup your files on a separe media/computer/CDROM.
>
> Don't upgrade unless you are sure all databases are dumped with backups.
>
> 2) Upgrade PostgreSQL
> It is recommanded to use PostgreSQL latest RPMs.
>
> For Mandrake, my list of installed RPMs is as follows:
> libecpg3-7.2.1-1mdk.i586.rpm
> libpgperl-7.2.1-1mdk.i586.rpm
> libpgsql2-7.2.1-1mdk.i586.rpm
> libpgsqlodbc0-7.2.1-1mdk.i586.rpm
> libpgtcl2-7.2.1-1mdk.i586.rpm
> postgresql-7.2.1-1mdk.i586.rpm
> postgresql-contrib-7.2.1-1mdk.i586.rpm
> postgresql-devel-7.2.1-1mdk.i586.rpm
> postgresql-docs-7.2.1-1mdk.i586.rpm
> postgresql-jdbc-7.2.1-1mdk.i586.rpm
> postgresql-python-7.2.1-1mdk.i586.rpm
> postgresql-server-7.2.1-1mdk.i586.rpm
> postgresql-tcl-7.2.1-1mdk.i586.rpm
> postgresql-test-7.2.1-1mdk.i586.rpm
> postgresql-tk-7.2.1-1mdk.i586.rpm
>
> In case of RedHat, the reuired packages can be downloaded freely from :
> http://www.rpmfind.net/linux/RPM/rawhide/1.0/i386/RedHat/RPMS/PByName.html
> http://www.rpmfind.net/linux/RPM/rawhide/1.0/i386/RedHat/RPMS/LByName.html
>
> Do not buy the "RedHat database system", this is a marketing solution for
> fools. It wron't provide you with anything more than http://www.rpmfind.net.
>
> Enter as root :
> rpm -Uvh packages_name1 package_name2 [..] package_nameN
>
> All packages should be listed and upgraded at once.
>
> 3) Enable ODBC server-side
> See my last mail:
> > enable TPCIP_socket in /var/lib/pgsql/data/postgresql.conf
> > list your client IP in /var/lib/pgsql/data/pg_hba.conf
> > create user foo with administrative rights
> restart postgresql
>
> 4) Download and install pgAdmin2 from http://pgadmin2.postgresql.org
>
> Connect to database template1 using user foo
> Re-create an empty database "foo" (replace "foo" with your database name).
>
> 5) Upload data in your database
>
> Connect as user postgres
> #root(at)localhost>su -postgres
>
> Upload data using pgsql
> #postgres(at)localhost>psql bar < filename.sql
>
> Done!
>
> Do not hesitate to come back on our list for more information.
> Cheers, Jean-Michel POURE
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
>
> -=-=-=- Jumbo Classifieds -=-=-=-
> -= View 1000's of jobs updated around the clock! =-
> -= http://JumboClassifieds.com =-
> -----------------------------------------------------------------------------
> Looking for Discounted PC Hardware or Software? Jumbo Classifieds now
> has more than 75,000+ computer related items in our Online Super Store.
> Visit: http://jumboclassifieds.com/computer
> -----------------------------------------------------------------------------
>