[GENERAL] migration from Sybase to Postgres

What is the most appropriate way to migrate a database form Sybase (SQL Anywhere 5.504) to Postgres? I found some shareware of freeware migration tools on the net, which are the best? Is it faster to use any of them them or just simply do it manually? Thanks Tomas ---(

re: [GENERAL] How to insert .xls files into database

> [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Klaver > > I guess the solution depends on what is a 'large amount of data'. The > most time consuming part is going to be converting the single data > elements at the top of each sheet into multiple elements. I would > create columns for the data

RE: [GENERAL] migration from Sybase to Postgres

> [mailto:[EMAIL PROTECTED] On Behalf Of > > On 7 Jul 2006 12:50:22 -, [EMAIL PROTECTED] > <[EMAIL PROTECTED]> wrote: > > What is the most appropriate way to migrate a database form > Sybase (SQL Anywhere 5.504) to Postgres? I found some > shareware of freeware migration tools on the net,

=?UTF-8?Q? Re: =3D???UTF-8?Q?re: [GENERAL] How to insert .xls...?=

> [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Klaver > > Dates don't transfer correctly. When I try it the date moves > two days ahead. I just checked it, on my computer it works fine, no date shift. Regards Tomas > ---(end of broadcast)---

[GENERAL] pgsql-general@postgresql.org

I am using Postgresql to store all my research related data. At the moment I am just finishing my PhD thesis and I want to cite postgresql correctly but can't find how to do it. Could somebody give me an advice? Many thanks tomas -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] citing postgresql

Tomas Scott Marlowe wrote: On Mon, Nov 17, 2008 at 11:09 AM, Tomas Lanczos <[EMAIL PROTECTED]> wrote: I am using Postgresql to store all my research related data. At the moment I am just finishing my PhD thesis and I want to cite postgresql correctly but can't find how to do it. Cou

[GENERAL] how to cite postgresql?

I am using Postgresql to store all my research related data. At the moment I am just finishing my PhD thesis and I want to cite postgresql correctly but can't find how to do it. Could somebody give me an advice? Many thanks tomas -- Sent via pgsql-general mailing list (pgsql-general@postgresq

[GENERAL] incorrect restore from pg_dumpall

Hello, I am trying to restore my databases stored by a pg_dumpall command in the Karmic Koala box. The restore command is the following: psql -f /media/disk/.../backup -U postgres I have a PostsgreSQL 8.4 installed from repositories with postgis1.4.1. I recognized that the tables with spatial ge

Re: [GENERAL] incorrect restore from pg_dumpall

your old postgis to your new postgis > library. > > P > > On Fri, Nov 27, 2009 at 4:11 PM, Tomas Lanczos wrote: > > Hello, > > > > I am trying to restore my databases stored by a pg_dumpall command in > > the Karmic Koala box. The restore command is the fol

[GENERAL] could not open file xxxx for writing: Permission denied

Hello, Using PostgreSQL 8.1.4, pgadmin III 1.6.0 in WinXP I tried to export a table using COPY (first time in postgresql, did many times in Sybase): COPY ml50jtsk_datum_v TO 'c:/postgresql/ml50jtsk.out'; I got the following errormessage: ERROR: could not open file "c:/postgresql/ml50jtsk.out" f

[GENERAL] Moving the database from winxp to linux

I am planning within few week to migrate the existing 8.1.4 postgresql database from winxp to 8.2 postgresql installed on linux (ubuntu). Is there any good tutorial for the task like this, event. do have somebody summarized some tricks and tips, at least? many thanks in advance and regards Tomas

Re: [GENERAL] Moving the database from winxp to linux

> [mailto:[EMAIL PROTECTED] On Behalf Of Chris > > Tomas Lanczos wrote: > > I am planning within few week to migrate the existing 8.1.4 > postgresql > > database from winxp to 8.2 postgresql installed on linux > (ubuntu). Is > > there any good tutorial for t

[GENERAL] Sounds silly ...

Hello, I uninstalled the Postrgressql 8.1.0-2 (Win XP Pro) and tried to install the version 8.1.1-1 instead. In the Service configuration window I put in all the required data. After clicking "next" I got an error message that user "XY was not found, and it will be created. During the installation

[GENERAL] export from views

Hello everybody, I am quite a newbie in the database business, so sorry for stupid questions. Is there any convenient and simple method/tool to export data from views to file, something like COPY TO (file) from a table? I am using WinXP and Postgresql 8.1. Many thanks in advance Tomas ---

[GENERAL] Postgres on WinXP - app on Cygwin

I am curious, whether is it possible to connect to a PostgreSQL database installed on WinXP for an application installed on the same box but running in the Cygwin environment (the app. is the GRASS GIS). many thanx Tomas ---(end of broadcast)--- T