Re: [HACKERS] Call for 7.5 feature completion

2005-08-26 Thread Junaili Lie
Hi all, Our organizations are doing a lot of real time reporting involving queries with multiple tables, and large tables. I found that two features are very nice to have: - Table Partition - Materialized view Thanks, J On 8/26/05, Ron Mayer [EMAIL PROTECTED] wrote: Alvaro Herrera wrote:

Re: [HACKERS] postmaster.pid disappeared

2005-05-26 Thread Junaili Lie
to do with this issue. Thanks for all the help, J On 5/24/05, Junaili Lie [EMAIL PROTECTED] wrote: Tom, I am not too sure how to determine the unlink call. Can you provide more information/instructions? In my case the pg_ctl reload -D /usr/local/pgsql deleted the postmaster.pid without

[HACKERS] postmaster.pid disappeared

2005-05-24 Thread Junaili Lie
Hi, I was redirected to this maillist when i asked questions on irc. I hope this is the right mailing list. I am running postgresql 7.4.8 on solaris 10 (and I compile and installed slony). Everytime I am trying to reload the configuration using pg_ctl reload -D $PGDATA, it deleted the

Re: [HACKERS] postmaster.pid disappeared

2005-05-24 Thread Junaili Lie
Hi, Thank you all for the respond. I should probably mentioned that postgres is maintained by smf, which is a service management tool in solaris 10. I asked our sys admin to remove postgres from being managed by smf. he did that. But right now he is having problem because the system could not

Re: [HACKERS] postmaster.pid disappeared

2005-05-24 Thread Junaili Lie
: Junaili Lie [EMAIL PROTECTED] writes: I am running postgresql 7.4.8 on solaris 10 (and I compile and installed slony). Everytime I am trying to reload the configuration using pg_ctl reload -D $PGDATA, it deleted the postmaster.pid and didn't create a new one. That's very strange