*********
QUESTION
*********

> Marian,
> 
> Please could you email me details of how to send you my coursework via
> FTP. I have installed Linux on my computer at home and have done labs /
> coursework from here.
> 
> I have successfully managed to connect to itsy from home and sent some
> files via FTP but I don't know where I need to 'put' my coursework
> database in order for you to read it.
> 
> Thank you in advance,
> 
> Peter Hope 
----------------------------------------------

******
ANSWER
******

Peter,

You will need to transfer your database (that you created on your machine) 
onto the Postgres server that runs on itsy on the port 5432. The simplest 
way of doing this is by using "pg_dump" (refer to the Post5greSQL User's Guide; 
a link to it exists on my web page; however, the address is:
http://www.PostgreSQL.ORG/docs/user/index.html)

Suppose your database is called peter_hope. Then, you do the following:
- on your machine, at the Linux prompt, you do
	$pg_dump peter_hope > peter_hope_db.out
- then, you ftp this file to itsy (wherever you want (have access))
- then, you log onto itsy (you can telnet from home);
- move to the directory where you put the "peter_hope_db.out" file;
- create a database (say you give it the same name)
	$createdb -p 5432 peter_hope
- load your database from the dump file
	$psql -p 5432 < peter_hope_db.out
- you can then connect to your database on itsy and check whether 
the restauration was completed successfuly
	$psql -p 5432 peter_hope

NOTE: The dump file is a text (ASCII) file. Look at it; you will find 
it interesting (I say no more).

Regards,

Marian