[GENERAL] Postgresql Web Hosting

Hi, I'm trying to migrate a site to a new hosting company. The backend uses postgresql 8 and php. Anyone have thoughts on decent hosting companies for this sort of thing? I'm just looking at shared hosting as this isn't a resource intensive site. Thanks, Matt -- Sent via pgsql-general mailing

[GENERAL] Re: Baffled by "Group By" Resolved and Thanks

Yeah, it was right under my nose. Figured it out just before I got your email. Thank you. Matt Friedman - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Matt Friedman" <[EMAIL PROTECTED]> Cc: "PgSql General List" <[EMAIL PROTE

[GENERAL] Baffled by "Group By" - Please help!

dex.uri_id AND index_type.type_id = index_uri.type_id GROUP BY index_uri.uri, index_uri.description, index_uri.title, index_type.type, index.word_count, index_type.icon ORDER BY sum DESC Matt Friedman ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Re: Bad book review

I have it and have found it very useful. Matt Friedman Spry New Media - Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "PostgreSQL-general" <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 11:06 PM Subject: Bad book review >

[GENERAL] Re: Re: SELECT (sometimes) returning Zero Rows?

ow would I go about fixing it? Many thanks, Matt Friedman - Original Message - From: "Christopher Sawtell" <[EMAIL PROTECTED]> To: "Matt Friedman" <[EMAIL PROTECTED]> Cc: "PgSql General List" <[EMAIL PROTECTED]> Sent: Tuesday, February 13,

[GENERAL] Re: SELECT (sometimes) returning Zero Rows?

1 rows=1 width=8) -> Index Scan using pr_article_pkey on pr_article (cost=0.00..2.03 rows=1 width=4) -> Seq Scan on pr_cat (cost=0.00..1.10 rows=10 width=28) EXPLAIN - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Ma

[GENERAL] Vacuum and Owner

ery important that the system tables are "vaccumed" in addition to my db tables? Matt Friedman

[GENERAL] Re: Trapping NOTICE using PHP

If you can run the program psql via php's exec command or something then the stdout might be available to you. Might work. If php is in safe mode this can be a challenge. Matt Friedman Spry New Media - Original Message - From: "Dan Wilson" <[EMAIL PROTECTED]&g

[GENERAL] Lock won't release

b. It says that other users are using the database. I'm assuming it's saying this because there's a lock on the table. Thanks for any help. Matt Friedman Spry New Media http://www.sprynewmedia.com Lead Programmer/Partner email: [EMAIL PROTECTED] phone: 250 744 3655 fax: 250 370 0436

[GENERAL] Table Locked - removing lock

I have a locked table that won't unlock. I do not appear to be able to select from the table. I suppose it's a deadlock, but I don't know how to release it. thanks, Matt Friedman

[GENERAL] pg_dump shell or php?

Any one written a shell or php script that runs pg_dump on a db say everyday or something?   Any suggestions?   thanks, Matt Friedman

[GENERAL] Re: postgres limitation -what does it mean? (8k row limit)

eat. thank you. Matt Friedman - Original Message - From: "Mitch Vincent" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 26, 2001 7:28 PM Subject: Re: postgres limitation > > > the max size of a row... > > > > 8k in pr