Re: [GENERAL] import *.backup-file (PostGIS - not mine)

2012-06-11 Thread Stefan Tzeggai
e, you'll need to provide a lot more detail for > us to know whether the file is at all useful to you. -- Stefan Tzeggai -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] backup script

2012-05-11 Thread Stefan Tzeggai
evaluate this new db software >> before the company can switch all oracle and mysql to postgres. I >> don't understand the concept how to create backup user, tablespace, > etc > > Welcome! > > Some of this happens in the database, some in the operating system

[GENERAL] Lost one tablespace - can't access whole database

2012-05-05 Thread Stefan Tzeggai
Hi postgresql 9.1 on Ubuntu 10.04 My database was spread over multiple tablespaces, spread over mutliple discs. Now i lost one of the discs = one tablespace. The database does start, but when I try to access the database, it complains psql: FATAL: could not open file ... I tried to point the s