[GENERAL] Export Data from one DB and Import into a new DB

Hello, we are changing the structure of our database from a new release. Now we need to export large amounts of data and import it into the new db( with a new structure). Are there any tools( for osx ) to support me doing this? Thanks for your help, Stefan Sturm -- Sent via pgsql-general

Re: [GENERAL] Need Tool to sync databases with 8.3.1

ownload this app looks and works really good, but there is no version for OSX :-( Does anybody know an application like this for OSX? Thanks, Stefan Sturm -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Optimizing a like-cause

do to speed up the Statement? What Index can I set? Thanks for your Help, Stefan Sturm -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Client Authentication

Hello, > try adding a subnet mask > host all username 0.0.0.0 0.0.0.0 md5 > or a cidr mask > host all username 0.0.0.0/0 md5 > > that's it. I don't know, why I only wrote 0.0.0.0... Thats cleary my fault. Thanks for all your help. Greetings, Urkman

[GENERAL] Client Authentication

: createuser -P username Then I add a new line to the pg_hba.conf file: hostall username 0.0.0.0 md5 I want to access all databases from all IP-Adresses with this user. But this fails :-( WHere is my Error? I hope some can help me. Thanks and greetings, Stefan

Re: [GENERAL] Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3

Hello, thanks for your ansers. PgSphere (http://pgfoundry.org/projects/pgsphere) > I think this look most promising. Is here someone using it and can give me some tipps? Thanks and greetings, Stefan Sturm

[GENERAL] Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3

... <http://dict.leo.org/ende?lp=ende&p=thMx..&search=km> Is there a simple way to do something like this? Thanks for your Help, Stefan Sturm

Re: [GENERAL] PostgreSQL Processes on a linux box

Hello, Am 11.04.2008 um 18:41 schrieb Andrew Sullivan: On Fri, Apr 11, 2008 at 03:09:43PM +0200, Stefan Sturm wrote: DBVisualizer stoped working and no I have two processes on my server: postgres 30873 0.0 0.7 46552 7124 ?Ss 12:33 0:01 postgres: postgres dbName 10.0.1.198

[GENERAL] PostgreSQL Processes on a linux box

46708 6500 ?Ss 13:07 0:00 postgres: postgres dbName 10.0.1.198(53799) SELECT waiting What can I do? OK, I can stop and start the Database, but I think there are other ways to handle this... What Tool can I use to kill such processes? Thanks and greetings, Stefan Sturm -- Sent

Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights

s. Is there a way to do it? Thanks, Stefan Sturm

Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights

When I copy libintl3.dll and libiconv2.dll to the system32 folder, I get the Error, that the applcattion could not get initilaized. Seams to be an odd problem. Thanks for your Help, Stefan Sturm Am 25.03.2008 um 12:17 schrieb Craig Ringer: Stefan Sturm wrote: Hello, If you can do that

Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights

ou have an incorrect version of the MSVC runtime on your system. See the README file in the download directory. I can't istall the runtime, because I can't run the MSI installer. The same problem :-( So, I thnk, there is no chance to install prostgres here :-( Greetings, Stefan Stur

Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights

Hello, I know that :-)It was just a try... Greetings, Stefan Sturm Am 25.03.2008 um 11:28 schrieb Craig Ringer: Stefan Sturm wrote: Hello, i copied the dll files to the system32 directory. That's really NOT a good idea. Win2k and up look in the executable directory for required

Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights

Hello Stefan Sturm wrote: Hello, is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000 Maschine without Admin Rights? Yes, but you cannot use the MSI installer, and you cannot install it as a service (for auto-start). You can download the binaries-no- installer and run the initdb

Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights

Hello, i copied the dll files to the system32 directory. But now I get another error: The Programm could not be initialized( 0xcc022 ) Any Hints? Stefan Sturm Stefan Sturm wrote: Hello, is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000 Maschine without Admin Rights? Yes

[GENERAL] Install Postgresql on Win2000 with Admin Rights

Hello, is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000 Maschine without Admin Rights? Thanks for your Help, Stefan Sturm -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Savepoint Problem

ction blocks How can I check, if there is an transaction? Thanks for your help, Stefan Sturm ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] Error with 8.0.0 Beta4

while processing the request.) With Beta3 I never got this Message. What's going wrong there? Greetings, Stefan Sturm ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Postgre and Web Request

from > the pool to use, and returns it back to the pool when done. Where can I find some examples for connection pooling with php? Or must I just use persistence connections? Greetings, Stefan Sturm ---(end of broadcast)--- TIP 4: Don&