Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostreSQL Single File ( Like M$ Access)

PostreSQL Single File ( Like M$ Access)

From
"Christian Teguh"
Date:
Hi guys, i just wondering, i there a way to make PostgreSQL database like M$ Access. That have only single or several files without installing it.?? Thanks for your attention.

Regards..

Christian

Re: PostreSQL Single File ( Like M$ Access)

From
Magnus Hagander
Date:
On Mon, Mar 10, 2008 at 01:43:03PM +0700, Christian Teguh wrote:
> Hi guys, i just wondering, i there a way to make PostgreSQL database like M$
> Access. That have only single or several files without installing it.??
> Thanks for your attention.

No.
Unless you create a file and mount a loopback filesystem on it, but I'm
sure that's not what you're looking for.

//Magnus

Re: PostreSQL Single File ( Like M$ Access)

From
Craig Ringer
Date:
Magnus Hagander wrote:
> On Mon, Mar 10, 2008 at 01:43:03PM +0700, Christian Teguh wrote:
>> Hi guys, i just wondering, i there a way to make PostgreSQL database like M$
>> Access. That have only single or several files without installing it.??
>> Thanks for your attention.
>
> No.
> Unless you create a file and mount a loopback filesystem on it, but I'm
> sure that's not what you're looking for.

Consequently you might want to look into embeddable databases like
SQLite, Firebird, Berkeley DB (NOT SQL), etc.

--
Craig Ringer

Re: PostreSQL Single File ( Like M$ Access)

From
"Uwe Seher"
Date:
On Mon, 10 Mar 2008 07:43:03 +0100, Christian Teguh
<christ.ian.teguh@gmail.com> wrote:

> Hi guys, i just wondering, i there a way to make PostgreSQL database
> like M$
> Access. That have only single or several files without installing it.??
> Thanks for your attention.
>
> Regards..
>
> Christian

No, thereis no postgres-way to do so, i think. But you can maybe export
your database into sqlite, which stores all in one file. But there is no
more multiuser-access or something else what is provided by a
database-server.

CU Uwe

Re: PostreSQL Single File ( Like M$ Access)

From
Chris Browne
Date:
christ.ian.teguh@gmail.com ("Christian Teguh") writes:
> Hi guys, i just wondering, i there a way to make PostgreSQL database
> like M$ Access. That have only single or several files without
> installing it.?? Thanks for your attention.

No, there isn't, just as there isn't a "make it faster" flag.

If you truly require that your database be stored in one file, then
you will need to consider some other database system.  I believe
SQLite and Firebird both are able to function as you evidently desire.
--
(reverse (concatenate 'string "gro.mca" "@" "enworbbc"))
http://linuxdatabases.info/info/oses.html
VERITAS AETERNA -- DON'T SETQ T.