Help

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Help

Paul Bramble

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.

Reply | Threaded
Open this post in threaded view
|

Re: Help

Stephan Szabo

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
Reply | Threaded
Open this post in threaded view
|

Re: Help

John R Pierce
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