Re: [ADMIN] Cannot close 'an error has occurred' dialogue box

2012-10-25 Thread Kevin Grittner
Adrian Heath wrote: > I am unable to click on the Ok button to close the dialog box or > either of the pgAdmin screens. I can drag the dialog box around the > screen but cannot close it. Only option is to terminate the pgAdmin > process. You might want to try posting this on the pgadmin-support l

[ADMIN] migrate from PostgreSQL to Oracle

2012-10-25 Thread jo
Hi all, I'm working with same db schema in PostgreSQL and Oracle, We mainly work in PostgreSQL but sometimes we need to copy schema and data from pg to oracle because some our customers want to use oracle instead of pg. Thus I'm looking for some linux script to migrate from pg to oracle. At the

Re: [ADMIN] migrate from PostgreSQL to Oracle

2012-10-25 Thread Gabriele Bartolini
Il 25/10/12 15:29, jo ha scritto: Is there any interesting linux script to do this more easily? something like the ora2pg script. Have you tried searching for pg2ora on Google? Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bar

Re: [ADMIN] migrate from PostgreSQL to Oracle

2012-10-25 Thread jo
Gabriele Bartolini wrote: Il 25/10/12 15:29, jo ha scritto: Is there any interesting linux script to do this more easily? something like the ora2pg script. Have you tried searching for pg2ora on Google? Cheers, Gabriele Yes Gabriele, this was the first thing that I did, but I did not find an

Re: [ADMIN] Cannot close 'an error has occurred' dialogue box

2012-10-25 Thread Adrian Heath
Kevin I did; yours is the first reply from either list. Adrian -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] migrate from PostgreSQL to Oracle

2012-10-25 Thread Walter Hurry
On Thu, 25 Oct 2012 15:29:29 +0200, jo wrote: > Hi all, > > I'm working with same db schema in PostgreSQL and Oracle, > We mainly work in PostgreSQL but sometimes we need to copy schema and > data from pg to oracle because some our customers want to use oracle > instead of pg. > > Thus I'm looki

[ADMIN] PostgreSQL 8.4 on OpenIndiana

2012-10-25 Thread Boris Epstein
Hello listmates, I am trying to move the data directory for this PG installation. So one question would be, how do I do that? What's the accepted practice? And if I want to split the storage - i.e., put databases into different directories - can I do that? At this point I tried to just move the

Re: [ADMIN] Database in psql

2012-10-25 Thread teyking2003
We might not consider upgrade our existing psql 8.2.5 to the latest one because of this psql version is bundle with our web application. and the whole system design by the vendor. we only can perform maintenance steps to that database, scare any side effect to our web application. any place to che

Re: [ADMIN] Error on pg_dumpall

2012-10-25 Thread Terry Khatri
On 23 October 2012 10:15, Craig Ringer wrote: > > First, try per-database dumps. Work out which database has the problem. > Do a: > > pg_dumpall -U sns84 --globals-only > globals.sql > > then for each database: > > pg_dump -U sns84 -f $dbname.sql $dbname > > (scripting it if desired),

Re: [ADMIN] Auto Vacuum

2012-10-25 Thread teyking2003
hi can anyone reply me on my database status base on the vacuum verbose provided? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Auto-Vacuum-tp5728770p5729574.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing l