C: FULL; Try to move Postgres to another harddrive

[oli2222]

Little Problem. There is no template1:

http://img262.imageshack.us/img262/1717 ... s09dt6.png

[ptrack pat]

Under the View menu select Show System Objects

[oli2222]

I don't find this option

http://img397.imageshack.us/img397/922/ ... s10nn2.png

[ptrack pat]

Look under the tools menu. I'm on vacation now, I don't have my computer with me. If you can't find it there, open the Help option and try searching for System Objects or something like that.

[oli2222]

ok found it.

I also found the mentioned tables. Do I have to delete these entries?

http://img47.imageshack.us/img47/5152/postgres11gd9.png

[ptrack pat]

You need to delete all 4 of those tables.

[oli2222]

Ups.. I had to drop / cascade and then the hole schema public is gone.
http://img208.imageshack.us/img208/631/ ... s13yw4.png

If I try to convert a database now I get a different error message:
http://img243.imageshack.us/img243/4130 ... s12gr6.png

Sorry if I am a bit of trouble.

[ptrack pat]

The only way it would have dropped the entire schema is if you dropped it instead of just the tables.

Click on the Tools > Query Tool option.

In the following window copy/paste the following...

CREATE SCHEMA public
AUTHORIZATION postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO public;
COMMENT ON SCHEMA public IS 'Standard public schema';

Now hit F5 to run it and hopefully it will recreate that schema.

[oli2222]

Ok, I think this worked and now i can convert databases to PostgresSQL. Thank you very much Pat!

One last question. The two original backup files I made from the old postgresSQL installation were like 200 mb together but my postgre folder is like 6,3 gb already with 10k hands more at max. How is this possible and can I do something against that?

[ptrack pat]

The backup files are compressed when you do the backups so they are always smaller than the actual size of your data folder. Also, all the indexes, etc. that take up a lot of space are not part of the backup, just the data is along with the schema needed to rebuild the tables and indexes when you restore.