Thread: Help

I am working on a product that uses a database for some elementary permanent
storage.  Currently we are using Firebird.



I have been asked to evaluate the product against Postgres, but I have
limited time to do so.



Is there an easy way to get started so I can quickly install Postgress and
load my schema?



Loaded message here - One of the reasons that I choose Firebird was that it
was very, very, very easy to use.  I am not having the same experience with
Postgres.  Any pointers as to how to get it set up enough to load imy schema
would not only be appreciated, but would be a point in Postgres's favor.



Regards,



Paul Bramble,

Vidiom Inc.

On Mon, 22 Aug 2005, Paul Bramble wrote:

> Is there an easy way to get started so I can quickly install Postgress and
> load my schema?

You didn't say what kind of system you're running, but getting a packaged
version of PostgreSQL (RPM, DEB, Windows Installer) will probably help on
the install side.

Once it's installed, you'll need to make an actual database and load the
schema file.  That might be as simple as doing something like the
following as the postgres user:
 createdb dbname
 psql dbname -f foo.sql

Stephan Szabo wrote:
> On Mon, 22 Aug 2005, Paul Bramble wrote:
>
>
>>Is there an easy way to get started so I can quickly install Postgress and
>>load my schema?
>
>
> You didn't say what kind of system you're running, but getting a packaged
> version of PostgreSQL (RPM, DEB, Windows Installer) will probably help on
> the install side.
>
> Once it's installed, you'll need to make an actual database and load the
> schema file.  That might be as simple as doing something like the
> following as the postgres user:
>  createdb dbname
>  psql dbname -f foo.sql
>

unless its been changed in the later releases, he'll also need to muck with the
default settings in the conf files before he'll be able to connect.