[ADMIN] plr installation

=not( lanpltrusted ) where lanname='plr'; thanks in advance -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

[ADMIN] function based index problem

-- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [ADMIN] function based index problem

more detailed suggestions, it would be best to abandon this thread and start a new one on that list. -Kevin analyze entry has solved the problem. Thanx a lot. -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

[ADMIN] db restore takes to long

Hi, im trying to restore 250GB database, but indexing takes too long, so restore takes more then 12h. Is it possible to disable indexing while restoring database? Thanx in advance -- --- Viktor Bojović --- Wherever I go

Re: [ADMIN] db restore takes to long

is the number of cores you have in your microprocessor. It then divides the restore script into different jobs and goes faster using multithreading. example: pg_restore --username postgres --jobs=4 --dbname=your_db_name your_dump_file Here is if you have a quad core. Adrien Viktor Bojović

[ADMIN] unknown type

is not of type integer,smallint or varchar. How can i find out which table has that unknown type? Thanx in advance -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [ADMIN] unknown type

which table has that unknown type? Try something like select attrelid::regclass, attname from pg_attribute where atttypid = 'unknown'::regtype; regards, tom lane that solved the problem. thanx -- --- Viktor Bojović

Re: [ADMIN] Drop Schema Error

schema name. so i renamed it again to drop those objects. It was 8.3.13 or prior version @ 32bit debian linux . -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [ADMIN] Migrating a live database

/ -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [ADMIN] how made procedure returned different types of value?

. it is possible? anybody? Maybe you can use custom types and store different results into that custom type container which will be returned by your function. -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [ADMIN] Find all running postgres DB servers on a network

ports for each address. you can use nmap scanner for that purpose. -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [ADMIN] GUI ERD/ERM tools?

tools, preferences, etc? Regards, Lou Picciano i prefer EMS postgre manager. but it is not free -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

Re: [ADMIN] PostgreSQL Select command that will list only duplicate rows

use of their e-mail facilities or e-mails sent other than strictly for business purposes. -- --- Viktor Bojović --- Wherever I go, Murphy goes with me

[ADMIN] drop table

-- --- Viktor Bojović --- Wherever I go, Murphy goes with me