PostgreSQL › PostgreSQL - bugs

Help

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

Paul Bramble

Help

I am working on a product that uses a database for some elementarypermanent 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 installPostgress and load my schema?

Loaded message here - One of the reasons that I chooseFirebird was that it was very, very, very easy to use. I am not having thesame experience with Postgres. Any pointers as to how to get it set up enoughto load imy schema would not only be appreciated, but would be a point inPostgres’s favor.

Regards,

Paul Bramble,

Vidiom Inc.

Stephan Szabo

Re: Help

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

John R Pierce

Re: Help

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.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq