Re: [despammed] Installation

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