Description:
General Discussions about PostgreSQL
|
|
|
Invalid redo in checkpoint record
|
| |
Hi, After a recent server crash after which the whole system hung and power had to be pulled, I'm having the following error pop up when trying to start the DB: * Starting PostgreSQL 8.4 database server * The PostgreSQL server failed to start. Please check the log output: 2009-11-26 16:00:23 GMT LOG: database system was interrupted; last known up... more »
|
|
|
transparently log a right error
|
| |
Hi list, How could I transparently log an error where user miss a right, I know how to write a RULE, but not this way: ie: * user don't have a direct access to tables but to procedures that manipulates tables. * He try to make a: SELECT * FROM table5 which normally returns: "ERROR: right refused for relation table5"... more »
|
|
|
Bestpractice for upgrading from enterpriseDB 8.3.3 to rpm 8.4.1.
|
| |
Is there anyone that has installed enterpriseDB (833) and upgraded to later version or 8.4.1 using rpms? I am wondering what the best path would be to upgrade from enterpriseDB. Can I do an upgrade from enterpriceDB 8.3.3 to rpms 8.3.8 without dumping and restoring the database? When going from enterpricedb 8.3.3 to 8.4.1 using rpms, can I have them simultaneously run in parrellel and export/import and remove enterprisedb 8.3.3 later, would there be any issues?... more »
|
|
|
READ ONLY & I/O ERROR
|
| |
...this looks more like filesystem corruption. What's the FS database is running on ? presumably ext3 (cos it is centos5). If possible, consider checking the root cause of FS corruption, possibly test on other FS (xfs?). Maybe you should also try to enable journaling, if you run in ext2/3 mode.
|
|
|
How are blobs (oid) stored?
|
| |
Hi all, I know this is none of the user's business, but I'm wondering how blob's implemented as oid are stored in the postgresql data storage. Are each of them kept in a separate file, or are they chunked into pieces and scattered ? Thanks ! Jerome.
|
|
|
Wiki page on vacuum full
|
| |
Hi folks Since it seems to come up a lot, I've added some info on the pitfalls of VACUUM FULL to the wiki: [link] It intentionally avoids going into details of why index bloat is created, etc, and just tries to provide accessible advice as to better solutions to the problems the user may be trying to address with VACUUM... more »
|
|
|
How use input parameter as path to COPY in function?
|
| |
I am missing something basic. How can I use an input parameter as the destination path in a COPY statement in a function. The following fails with a syntax error at or near the parameter. CREATE OR REPLACE FUNCTION dvd.export_tables(IN export_path text) RETURNS void AS $$ BEGIN copy dvd.genre to export_path... more »
|
|
|
Mysql migration to Postgresql
|
| |
Hello, Currently, we are using Mysql: we would like to change. Now, we would like to use Postgresql. Only problem is that most of our customer addresses and other information are on Mysql. Can you help us with this? Thank you.
|
|
|
change of oid values?
|
| |
Hi, I'd like to know if the values of postgres's Oids can changes its values for the same object. I want to use them in my aplication, but I'm afraid they could change and I get errors. I use the field Oid of table pg_type to identify the type of a field in a query. It could bring me errors in the future? For example, the oid value associated to type int4 could change at any future time?... more »
|
|
|
|
