Thread: Installation
Hi, I have a WXP Professional machine. This one is my first contact with PostgreSQL, so before starting I would like to know which file should I download and install in my machine. Where could I find a document about PostgreSQL installation? I already made a test before formating my machine and reinstalling my OS last week and found some problems trying to use the PostgreSQL admin interface from my account which has admin privileges. For your attention, thanks in advance. Best regards, Jorge Perez
am 03.01.2005, um 10:49:42 -0500 mailte Jorge Pérez folgendes:
> Hi,
>
> I have a WXP Professional machine. This one is my first contact with
> PostgreSQL, so before starting I would like to know which file should I
> download and install in my machine. Where could I find a document about
which version? Versions earlier 8.0 need a cygwin-environment under
windows. You should install cygwin, and from the cygwin-installer you
can install PostgreSQL.
> PostgreSQL installation? I already made a test before formating my
> machine and reinstalling my OS last week and found some problems trying
^^^^^^^^^^^^^^^^^^
Why WXP, why not Linux? ;-)
> to use the PostgreSQL admin interface from my account which has admin
> privileges.
For more help, the experts needs detailed error-messages.
Regards, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Tel. NL Heynitz: 035242/47212
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
Hi Andreas; That's what I am asking. Which file should I download from the PostgreSQL site to install under Windows Xp Professional? I don't pretend to install the source files, I just need to install the database and the admin console. Why not Linux? Well, I develop with Microsoft tools, so my OS has to be Windows. And about my last question - problems with the Administration Tool -, I just wanted to know if it's possible to get a white paper with a description on how to install correctly the database in my OS, just to avoid errors and get it working at once. Best regards, Jorge Perez Andreas Kretschmer wrote: >am 03.01.2005, um 10:49:42 -0500 mailte Jorge Pérez folgendes: > > >>Hi, >> >>I have a WXP Professional machine. This one is my first contact with >>PostgreSQL, so before starting I would like to know which file should I >>download and install in my machine. Where could I find a document about >> >> > >which version? Versions earlier 8.0 need a cygwin-environment under >windows. You should install cygwin, and from the cygwin-installer you >can install PostgreSQL. > > > > > >>PostgreSQL installation? I already made a test before formating my >>machine and reinstalling my OS last week and found some problems trying >> >> > ^^^^^^^^^^^^^^^^^^ > >Why WXP, why not Linux? ;-) > > > > >>to use the PostgreSQL admin interface from my account which has admin >>privileges. >> >> > >For more help, the experts needs detailed error-messages. > > > >Regards, Andreas > >
Hello Jorge; I was in the same place as you about a month ago. I'm running home edition and I've got it working. Following is a quote from the email I received from the list. (updated to reflect new RC) Ray >Your best bet as a new Windows user is to download the distribution from >here which includes a complete Windows installer: >http://pgfoundry.org/frs/?group_id=1000007 >(or more specifically, this is the latest release: >http://pgfoundry.org/frs/download.php/95/postgresql-8.0.0-rc2.zip). >It should prompt you for everything you need to get the database up and >running. The documentation and pgAdmin, a graphical PostgreSQL client is >included. >> Hi Andreas; >> >> That's what I am asking. Which file should I download from the PostgreSQL >> site to install under Windows Xp Professional? I don't pretend to install >> the source files, I just need to install the database and the admin >> console. Why not Linux? Well, I develop with Microsoft tools, so my OS >> has to be Windows. And about my last question - problems with the >> Administration Tool -, I just wanted to know if it's possible to get a >> white paper with a description on how to install correctly the database >> in my OS, just to avoid errors and get it working at once. >> >> Best regards, >> >> Jorge Perez >> >> Andreas Kretschmer wrote: >> >>>am 03.01.2005, um 10:49:42 -0500 mailte Jorge Pérez folgendes: >>> >>>>Hi, >>>> >>>>I have a WXP Professional machine. This one is my first contact with >>>>PostgreSQL, so before starting I would like to know which file should I >>>>download and install in my machine. Where could I find a document about >>> >>>which version? Versions earlier 8.0 need a cygwin-environment under >>>windows. You should install cygwin, and from the cygwin-installer you >>>can install PostgreSQL. >>> >>> >>> >>> >>>>PostgreSQL installation? I already made a test before formating my >>>>machine and reinstalling my OS last week and found some problems trying >>> ^^^^^^^^^^^^^^^^^^ >>> >>>Why WXP, why not Linux? ;-) >>> >>> >>> >>>>to use the PostgreSQL admin interface from my account which has admin >>>>privileges. >>>> >>> >>>For more help, the experts needs detailed error-messages. >>> >>> >>> >>>Regards, Andreas >>> -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.7 - Release Date: 12/30/2004
am Mon, dem 03.01.2005, um 12:29:14 -0500 mailte Jorge Pérez folgendes: > Hi Andreas; > > That's what I am asking. Which file should I download from the > PostgreSQL site to install under Windows Xp Professional? I don't Look at http://www.cygwin.com/ There are a windows-installer. Use it, there is a option to install PostgreSQL. Read the manual. > and the admin console. Why not Linux? Well, I develop with Microsoft > tools, so my OS has to be Windows. And about my last question - problems > with the Administration Tool -, I just wanted to know if it's possible > to get a white paper with a description on how to install correctly the > database in my OS, just to avoid errors and get it working at once. Cygwin is a UNIX-like environment for Win32. Use it, and you have the (almost) same environment like under *NIX. Read the nice manual from http://postgresql.org for more information. I'm using Cygwin rarely, for instance, to enable a ssh-like access to windows. But i know, that there are a option to install PostgreSQL. After installation you should make a database with createdb and a database-user with createuser. Regards, Andreas -- Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau- fenden Pinguins aus artgerechter Freilandhaltung. Er ist garantiert frei von Micro$oft'schen Viren. (#97922 http://counter.li.org) GPG 7F4584DA Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)
Thanks a lot to you all, now it's running perfectly :-) . I have a project in which I'm going to use PostgreSQL database and Visual FoxPro (which can be used with Linux) for the front end. What has to be done to install a database developed in a Windows machine in a Linux server? Best regards, Jorge Perez Afton & Ray Still wrote: > Hello Jorge; > > I was in the same place as you about a month ago. I'm running home > edition and I've got it working. Following is a quote from the email I > received from the list. (updated to reflect new RC) > Ray > >> Your best bet as a new Windows user is to download the distribution >> from here which includes a complete Windows installer: > > >> http://pgfoundry.org/frs/?group_id=1000007 > > >> (or more specifically, this is the latest release: >> http://pgfoundry.org/frs/download.php/95/postgresql-8.0.0-rc2.zip). > > >> It should prompt you for everything you need to get the database up >> and running. The documentation and pgAdmin, a graphical PostgreSQL >> client is included. > > > >>> Hi Andreas; >>> >>> That's what I am asking. Which file should I download from the >>> PostgreSQL site to install under Windows Xp Professional? I don't >>> pretend to install the source files, I just need to install the >>> database and the admin console. Why not Linux? Well, I develop with >>> Microsoft tools, so my OS has to be Windows. And about my last >>> question - problems with the Administration Tool -, I just wanted to >>> know if it's possible to get a white paper with a description on how >>> to install correctly the database in my OS, just to avoid errors and >>> get it working at once. >>> >>> Best regards, >>> >>> Jorge Perez >>> >>> Andreas Kretschmer wrote: >>> >>>> am 03.01.2005, um 10:49:42 -0500 mailte Jorge Pérez folgendes: >>>> >>>>> Hi, >>>>> >>>>> I have a WXP Professional machine. This one is my first contact >>>>> with PostgreSQL, so before starting I would like to know which >>>>> file should I download and install in my machine. Where could I >>>>> find a document about >>>> >>>> >>>> which version? Versions earlier 8.0 need a cygwin-environment under >>>> windows. You should install cygwin, and from the cygwin-installer you >>>> can install PostgreSQL. >>>> >>>> >>>> >>>> >>>>> PostgreSQL installation? I already made a test before formating my >>>>> machine and reinstalling my OS last week and found some problems >>>>> trying >>>> >>>> ^^^^^^^^^^^^^^^^^^ >>>> >>>> Why WXP, why not Linux? ;-) >>>> >>>> >>>> >>>>> to use the PostgreSQL admin interface from my account which has >>>>> admin privileges. >>>>> >>>> >>>> For more help, the experts needs detailed error-messages. >>>> >>>> >>>> >>>> Regards, Andreas >>>> > > >
--- Jorge P�rez <jlperez@epm.net.co> wrote: > Thanks a lot to you all, now it's running perfectly > :-) . I have a > project in which I'm going to use PostgreSQL > database and Visual FoxPro > (which can be used with Linux) for the front end. > What has to be done to > install a database developed in a Windows machine in > a Linux server? Look at the "pg_dumpall" utility (covered under "client applications" in the documentation). This will allow you to recreate an entire database setup. "pg_dump" will do the same for a single database. Take note that you may have difficulty if there are users in the original database setup that do not exist in the setup that you are restoring to. The "pg_dumpall" file will contain commands to recreate all of your users, but you will still need to be careful to avoid conflicts in the superuser name. You may need to edit the dump file to resolve these problems. > > Best regards, > > Jorge Perez > > > > Afton & Ray Still wrote: > > > Hello Jorge; > > > > I was in the same place as you about a month ago. > I'm running home > > edition and I've got it working. Following is a > quote from the email I > > received from the list. (updated to reflect new > RC) > > Ray > > > >> Your best bet as a new Windows user is to > download the distribution > >> from here which includes a complete Windows > installer: > > > > > >> http://pgfoundry.org/frs/?group_id=1000007 > > > > > >> (or more specifically, this is the latest > release: > >> > http://pgfoundry.org/frs/download.php/95/postgresql-8.0.0-rc2.zip). > > > > > >> It should prompt you for everything you need to > get the database up > >> and running. The documentation and pgAdmin, a > graphical PostgreSQL > >> client is included. > > > > > > > >>> Hi Andreas; > >>> > >>> That's what I am asking. Which file should I > download from the > >>> PostgreSQL site to install under Windows Xp > Professional? I don't > >>> pretend to install the source files, I just need > to install the > >>> database and the admin console. Why not Linux? > Well, I develop with > >>> Microsoft tools, so my OS has to be Windows. And > about my last > >>> question - problems with the Administration Tool > -, I just wanted to > >>> know if it's possible to get a white paper with > a description on how > >>> to install correctly the database in my OS, just > to avoid errors and > >>> get it working at once. > >>> > >>> Best regards, > >>> > >>> Jorge Perez > >>> > >>> Andreas Kretschmer wrote: > >>> > >>>> am 03.01.2005, um 10:49:42 -0500 mailte Jorge > P�rez folgendes: > >>>> > >>>>> Hi, > >>>>> > >>>>> I have a WXP Professional machine. This one is > my first contact > >>>>> with PostgreSQL, so before starting I would > like to know which > >>>>> file should I download and install in my > machine. Where could I > >>>>> find a document about > >>>> > >>>> > >>>> which version? Versions earlier 8.0 need a > cygwin-environment under > >>>> windows. You should install cygwin, and from > the cygwin-installer you > >>>> can install PostgreSQL. > >>>> > >>>> > >>>> > >>>> > >>>>> PostgreSQL installation? I already made a test > before formating my > >>>>> machine and reinstalling my OS last week and > found some problems > >>>>> trying > >>>> > >>>> ^^^^^^^^^^^^^^^^^^ > >>>> > >>>> Why WXP, why not Linux? ;-) > >>>> > >>>> > >>>> > >>>>> to use the PostgreSQL admin interface from my > account which has > >>>>> admin privileges. > >>>>> > >>>> > >>>> For more help, the experts needs detailed > error-messages. > >>>> > >>>> > >>>> > >>>> Regards, Andreas > >>>> > > > > > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose > an index scan if your > joining column's datatypes do not match > __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail