Databases

NAVIGATION

Backing up and restoring a database with the SELinux pg_user problem.

Hi all,Returning to a really old problem that is biting me againWe upgraded our server (from Fedora Core 3 to Core 5), and thusupgraded Postgres. Unfortunately, we did not know that the newversion of Postgres included with 5 uses a different data format thanthat included with 3. Thus, we need to...

2 answers | 3520 bytes |

space not reclaimed after repeated full vacuums

I left this running over the weekend, and was surprised tofind the script still running in it's 25th iteration thismorning, with basically no rows left in any of the non-static tables.The interesting thing was that the data partition still hadalmost 26GB of space used, no matter how much da...

0 answers | 572 bytes |

space not reclaimed after repeated full vacuums

Hi all:I'm running Pgsql 7.4.6 on Red Hat Enterprise Linux 3.0 (UR4 and UR6).My question/problem is around how much disk space PostgreSQL uses whentables are grown (by a restore) and then shrunk down again (delete + vacuum).When I initialize my database and load my schema df tells me that 6...

0 answers | 1823 bytes |

OLEDB connection does not want to work. Help!

Hi all, I am pulling my hair trying to make work an LEDBconnection to PSTGRES.Let me anticipate that, except for the connection stringI am using the same code (VB.NET, ) that has alreadyproved to work fine with all the following systems:sqlserver, Mysql, db2, access,[to say although I know nothi...

5 answers | 1462 bytes |

How to bypass perm pb on information schema. Request of review

Hi list, since up to now information_schema is pretty 'severe' in giving info that can be retrieved easily using '\d'or '\d table_name', I tried to write some queries for sqlalchemy (the RM for python) to make it work correctly. I used "psql -E + \d" to spy how post...

0 answers | 2657 bytes |

Wrap (obfuscate) code

Good afternoon.I'm not sure if this is the correct list, so please forgive me if it's not.I was wondering if there's a mechanism (or if not, a workaround) toobfuscate server code (PL/PgSQL), a la 's PL/SQL Wrap Utility:#LNPLS016Thanks for your time.Regards,Rodrigo(end of broa...

13 answers | 582 bytes |

failed to installing SAP NetWeaver 04 TESTDRIVE SR1

I am trying to install SAP NetWeaver 04 TESTDRIVE SR1 (SAP WebApplication Server on Linux), but encountered following problem:SUSE LINUX Enterprise Server 9 (i586)Installing sapj2ee-srv-sapdb-6.40-2Preparing[100%] 1:sapj2ee-srv-sapdb[100%]Installing sapdb-7.5-2Preparing[100%] 1:sapdb[100%]Instal...

2 answers | 1026 bytes |

Null attributes

How can I get all attributes that is not null + don't have defaults + isnot PKs? I know I have to use system catalog, but I have some Pks that ismulticolumn! Any help?Rodrigo SakaiAdministrador de Banco de Dados*(11) 3750-7075* rodrigo.sakai (AT) zanthus (DOT) com.br...

0 answers | 331 bytes |

Postgres & CODA

I've been reading a lot of documentation trying to find a way to implement a Postgres database on CDA and get it distributed that way. Unfortunately, I found out that CDA apparently doesn't support concurrency over databases, so i came up with an idea of using files, each file containi...

0 answers | 1302 bytes |

Performance of two queries, why such big difference ?

>Yes, but it completes the first query in 1ms somehow, so where is the>difference ?From your original email>WHERE channel = ? AND time >= ?>RDER BY time ASC ">WHERE channel IN (-2,?) AND time >= ?>RDER BY time ASC " the WHERE clause is different, that is why you are getti...

0 answers | 1978 bytes |

AW: Caluculation with date

Any date calculation is in days. I.e. you have to multiply your result by 24 and then by 60 to get the result in minutes.SQLselect (to_date('27.06.2006 13:22:12', 'dd.mm.yyyy hh24:mi:ss') 2 - to_date('25.06.2006 12:48:50', 'dd.mm.yyyy hh24:mi:ss')) * 24 *...

1 answers | 928 bytes |

i have a problem of privilages

I am not an expert in postgres, may this work for you.REVKE INSERT,UPDATE,DELETE N ALL from PUBLIC;it will take the INSERT,UPDATE,DELETE permmission from all users for allobjects in the database.If you want to give permission for a specific user on all objectsGRANT ALL on ALL to <user_name>...

0 answers | 1935 bytes |