Re: [ADMIN] opportunities of inline funtions

Hi. Really sorry, previous post was completely inconsistent. Actually, in addition, RULES exists. I use postgresql-7.3.5. Here the dump - CREATE TABLE t_test ( id integer, message text ); CREATE VIEW vw_test AS SEL

[ADMIN] pg_autovacuum is not working

Hi list This is my first post here, and I've searched google but couldn't find the solution. I'm trying to run pg_autovacuum on all my databases. All my Debian sarge machines use version 7.4.5-3 postgresql install postgresql-client

[ADMIN] pg_restore error

Hallo I try to restore a large DB with BLOBS. I created the dump file with: pg_dump -Fc -b > dump.file During the restore process startet with the following command: pg_restore -d dump.file the process breakes with the error message that a table couldn't be found. So I started the pg_restore

Re: [ADMIN] pg_restore error

Hi > I thought, that pg_restore will organize the restore-prozess in an optimal > order. This seems not work correct!!?? I would be grateful to hear any > hints. pg_restore does not priortize till now idealy it must be like restoring the functions >> tables >> views >> seqences so on... This

Re: [ADMIN] pg_restore error

Vishal Thank you for your answer. My problem is, I have to restore BLOBS. The documentation says, it's only possible to restore blobs with pg_restore in one part. The way you suppose does not work with BLOBS because the restauration of single objects will not restore BOLBS. Horst Düster -Urs

Re: [ADMIN] pg_restore error

Hi, Try "pg_restore -l" to generate a TOC. You may rearrange the TOC file. Then use "pg_restore -L". Hope it helps, Janko Richter Düster Horst wrote: Vishal Thank you for your answer. My problem is, I have to restore BLOBS. The documentation says, it's only possible to restore blobs with pg_restore

Re: [ADMIN] pg_restore error

OK, the manual talk about this solution, but I do have more than 2000 objects in my DB. What is the reason that pg_dump/pg_restore are not able to create an correct order ob DB objects with respect to their constraints. All tables must be created before the views are created and so on? Horst ---

[ADMIN] postgres slow in the latest version

Hello, maybe some known issues regarding subj. in version 7.4.5? I have a web application which is gathering date from postgre DB. And with a bach of row the problem starts appearing. Everything's ok in v7.4.2. My DB is indexed. Thanks! Edgars ---(end of broadcast)--

Re: [ADMIN] pg_autovacuum is not working

Hi Ivan, I had the same experience as you. I swear I did all the things required. Eventually it started working with enough postmaster restarts and fiddling with the files. I'm sorry I can't be more helpful, cause I was never quite sure why it finally decided to start working... Keep fiddling a

[ADMIN] Replication Options.

Hi , I need to implement the following the replication scenario in postgres database. Here are the details of what we are looking to implement. Lets say I have 2 nodes Node1(US) and Node2(Canada), Node1: tableA , tableB Node2: tableB , tableA tableA in Node1 is the master and it should replic

Re: [ADMIN] pg_autovacuum is not working

The problem was in my resolve.conf, the nameserver I've set is my datacenter provider who have localhost.provider.net point to 127.0.0.1 and postmaster couldn't bind to that host. For whatever reason. It does not check /etc/hosts too so I'll play with it on Mondey. На 29.10.2004 18:20 вие напис

Re: [ADMIN] pg_ctl stop -m fast

Thanks Tom. May I ask in which version this bug is fixed? -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 11:10 AM To: Lee Wu Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] pg_ctl stop -m fast "Lee Wu" <[EMAIL PROTECTED]> writes: > They claim on

[ADMIN] runaway processes, data corruption

Hi all, I've encounter a couple of bugaboos recently in a production database I run (7.3.4 on Solaris 8). One is that killing a query from a client tool such as dbVisualizer can cause the process on the server to become a runaway, consuming CPU and causing other processes to go into a TIME_WAIT

[ADMIN] psql won't "createdb"

This is kinda weird. I'm using the pg8 beta4. When I install on Win 2k3 server, it lets me do everything I want to do through pgAdmin, however I prefer the console based psql. Problem is, when I connect to template1 (or anything else) I'm unable to "createdb". This happens when I attempt it w/o

[ADMIN] How to relocate temporary files

I have a database that's about 18GBs. [base]# du -hs 17165 18G 17165 Occasionally someone runs a query and they get "could not write block 460593 of temporary file: No space left on device" At present the filesystem for the database has about 3GB free. I'd like to give the temporary files a f

[ADMIN] pg_ctl stop -m fast

Hi,   One of our customers complains about pg_ctl stop -m fast could not shutdown PG server though we cannot reproduce the same problem here.   They claim only "-m immediate" can take PG down after issuing "-m fast".   The PG version is 7.3.2.   What might prevent "-m fast" to shutdown PG (long

[ADMIN] unregister [EMAIL PROTECTED]

---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [ADMIN] How to relocate temporary files

[EMAIL PROTECTED] writes: > I'd like to give the temporary files a filesystem of their own. > What would be the preferred method? Change the subdirectory $PGDATA/base//pgsql_tmp/ into a symlink to someplace on another filesystem. regards, tom lane

Re: [ADMIN] psql won't "createdb"

Do you have sufficient space and is your file system NTFS -- With Best Regards, Vishal Kashyap. Did you know SaiPACS is one and only PACS Management tool. http://saihertz.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Replication Options.

[EMAIL PROTECTED] (Pallav Kalva) writes: > I need to implement the following the replication scenario in > postgres database. Here are the details of what we are looking to > implement. > > Lets say I have 2 nodes Node1(US) and Node2(Canada), > > Node1: tableA , tableB > Node2: tableB , tableA

Re: [ADMIN] pg_restore error

I had the problem in 7.3.2. Postgres pg_restore reied to restore views before tables. I had to use -l to generate a dump list and change the order of restore manually and restore with -L -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Düster Horst Sent: