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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

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 ===

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

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 8: explain analyze is your friend

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.ph...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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

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° ;-)

---------------------------(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

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.ph...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

--- 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.ph...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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org