Re: [GENERAL] incorrect restore from pg_dumpall

library. P On Fri, Nov 27, 2009 at 4:11 PM, Tomas Lanczos lanc...@t-zones.sk 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 following: psql -f /media/disk/.../backup -U postgres I have

[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

[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

[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

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. Could somebody

[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 the task like this, event. do have somebody

[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

=?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)--- TIP

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, which

[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 in

[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)---

[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] 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