Here results of what I've done.
Just a note all this was done on 7.4.16:
First of all problems:
1. cannot complete configure on flass drive
./configure --prefix=/media/sda1/app/psql/postgresql-7.4.16/bin
--without-readline
...
configure: creating ./config.status
config.status: creating GNUmakefile
config.status: creating src/Makefile.global
config.status: creating src/include/pg_config.h
config.status: linking ./src/backend/port/tas/dummy.s to
src/backend/port/tas.s
ln: creating hard link `src/backend/port/tas.s' to
`./src/backend/port/tas/dummy.s': Operation not permitted
config.status: error: cannot link src/backend/port/tas.s to
./src/backend/port/tas/dummy.s
configure: creating ./config.status
config.status: creating GNUmakefile
config.status: creating src/Makefile.global
config.status: creating src/include/pg_config.h
config.status: linking ./src/backend/port/tas/dummy.s to
src/backend/port/tas.s
ln: creating hard link `src/backend/port/tas.s' to
`./src/backend/port/tas/dummy.s': Operation not permitted
config.status: error: cannot link src/backend/port/tas.s to
./src/backend/port/tas/dummy.s
2.Then I build the source in knopixx directory. Build was
successfull.
An attempt to init database on flash drive failed:
[EMAIL PROTECTED]:/ramdisk/home/knoppix/test/build/bin$ ./initdb -D
/media/sda1/app/psql/rdata
The files belonging to this database system will be owned by user
"knoppix".
This user must also own the server process.
The database cluster will be initialized with locale C.
creating directory /media/sda1/app/psql/rdata/pg_xlog... ok
creating directory /media/sda1/app/psql/rdata/pg_clog... ok
selecting default max_connections... 100
selecting default shared_buffers... 1000
creating configuration files... ok
creating template1 database in /media/sda1/app/psql/rdata/base/1...
PANIC: could not link file
"/media/sda1/app/psql/rdata/pg_xlog/xlogtemp.30300" to
"/media/sda1/app/psql/rdata/pg_xlog/0000000000000000" (initialization
of log file 0, segment 0): Operation not permitted
./initdb: line 644: 30300 Aborted "$PGPATH"/postgres
-boot -x1 $PGSQL_OPT $BOOTSTRAP_TALK_ARG template1
initdb: failed
initdb: removing data directory "/media/sda1/app/psql/rdata"
[EMAIL PROTECTED]:/ramdisk/home/knoppix/test/build/bin$
However I made it work.
Here the work around:
=====================
tar build and data directories and copied over to flash drive. and
when knopix starts I copied it in any directory and it works
restart knopixx
untar data.tar and build.tar into the same directory (just to make it
easy)
Let's try to run:
[EMAIL PROTECTED]:~/db/build/bin$ psql test
psql: error while loading shared libraries: libpq.so.3: cannot open
shared object file: No such file or directory
[EMAIL PROTECTED]:~/db/build/bin$
Opps! missing library, fixing it by setting LD_LIBRARY_PATH. Since
the old value not (in my case) set doing it like this:
[EMAIL PROTECTED]:~/db/build/bin$ export
LD_LIBRARY_PATH=/ramdisk/home/knoppix/db/build/lib
[EMAIL PROTECTED]:~/db/build/bin$ psql test
Welcome to psql 7.4.16, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
test=# \d
List of relations
Schema | Name | Type | Owner
--------+------+-------+---------
public | the | table | knoppix
(1 row)
test=# select * from the;
name
-------
abcde
(1 row)
test=# \q
[EMAIL PROTECTED]:~/db/build/bin$
Note: The table was create before and was a part od data directory.
TA-DA! It works!!!
the build and data didn't took much space:
2718136 data.tar
14919680 build.tar
OS used: Knopixx 2007-01-04
Kernel: Linux Knoppix 2.6.19
PC Memory 512 MB
This is good enough in my case I probably will re-burn knoppix CD to
include those two tar files - just need to find how, but this is a
different story.
It loos like tar-ing data directory does the work for keeping data
stored back to flash drive, however pg_dump is also can be used.
So, the only problem I had was with creating links and if anybody has
an idea how it can be fixed, can you let me know.
Cheers!
Mark
--- Merlin Moncure <[EMAIL PROTECTED]> wrote:
> On 3/28/07, Mark <[EMAIL PROTECTED]> wrote:
> > Hi Merlin,
> > Can you point where I can find build instructions for 7.4.X?
> > or in which sequence I should build sources from
> > http://www.postgresql.org/ftp/source/v7.4.16/
> >
> > Thanks a lot,
> > Mark
> > --- Merlin Moncure <[EMAIL PROTECTED]> wrote:
> >
> > > On 3/28/07, Mark <[EMAIL PROTECTED]> wrote:
> > > > Ideally, I'd like to have all postgresql related files on
> flush
> > > > drive. and OS on another device (CD). Database data will be
> small
> > > and
> > > > I don't think I will run into the problem with a space.
> > > >
> > > > But how can I install postgresql (including all libraries) on
> > > flash
> > > > drive? I remember that 7.4.X rpms always get installed into
> /usr
> > > > which is ramdrive in my case. Is it possible?
> > >
> > >
> > > Install from source. You get to omit ssl which you probably
> dont
> > > need
> > > and set the prefix in the configure statement...you will need
> to
> > > set
> > > up your own startup script though, add the binaries to the path
> > > yourself, and set your own PGDATA.
>
> it's easy...download, untar sources
> ./configure [--prefix=/xyz]
> make
> make install
>
> whatever your reasoning for 7.4, overrule them and get something
> more modern :-)
>
> merlin
>
____________________________________________________________________________________
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
http://mobile.yahoo.com/mail
---------------------------(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
