[ADMIN] PostgreSQL

2010-12-30 Thread nextage Tech
How good are certmagic.com practice exams for PostgreSQL exam? My friends told me they are pretty good and he has passed many exams with their material. Let me know guys! -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql

[ADMIN] Set up a database without backup

2007-07-24 Thread tech
Hello everybody. I’m using PostgreSQL on Windows XP. I had to format de harddisc, and I’m lost databases and tablespaces configuration (1 database and 1 tablespace), I have a copy of directory where was the tablespaces ( but I haven’t a backup made by pgAdmin ). What do I for set up my database

[ADMIN] simple_heap_delete LargeObjectDrop ERROR messages

2003-07-31 Thread tech techie
Greetings! I'm a new (very new) postgresql dba, and I was wondering if the following error messages are 'Normal' in your environments. I've already gone into single user mode and issued 'reindex database dbname', yet these messages still persist. Thanks in advance for any help or tips you ha

Re: [ADMIN] LargeObjectDrop and simple_heap_delete - Are these errors normal?

2003-07-30 Thread tech techie
More information: I'm running PostgreSQL version 7.3.2 on linux RH 8.0 (Linux version 2.4.18-14smp ([EMAIL PROTECTED]) (gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)) After the most recent 'crash' I went into single user mode, and did the following: 1) reindex database dbname --> 5 minut

[ADMIN] LargeObjectDrop and simple_heap_delete - Are these errors normal?

2003-07-30 Thread tech techie
Greetings! I'm a dba new to postgresql and I wanted to learn about these two error messages. I am getting these errors quite often and I'm wondering what it might be that is causing them. Could it be bad indexes? ...I've opened the database up in single user mode, and ran a 'reindex dat