Re: [GENERAL] incorrect restore from pg_dumpall
Yes, You were right, the problem was in the different libraries. I worked around by installing the postgis version 1.3.6, reloading the databases and subsequently uprading the postgis to 1.4.1. Thank You for Your help Tomas p.s.: what is really a mystery that also the mentioned table with no data were successfully reloaded, those tables did not contain spatial data ... :) On Fri, 2009-11-27 at 16:28 -0800, Paul Ramsey wrote: > In order to restore a backup taken with pg_dumpall you'll want to > ensure that the postgis installed in your new system is identical to > the postgis in your old one. This is because the postgis function > definitions will be looking for a particular postgis library name... > the name of the library from your old database. > > You can hack around this, and have your cake and eat it too, to an > extent, by symlinking the name of 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 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 geometries were not restored > > but at the moment I am almost sure that it's caused by that the older > > version of postgis in the stored database. What is a kind of mystery for > > me that data in several tables were not restored, although the table > > definitions did (it means that I got several tables without data) > > althoug the data are there in the backup file (I checked physically). I > > really don't understand what's going on there, I did the same many times > > before, without any problem. > > > > Tomas > > > > > > > > > > -- > > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[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 geometries were not restored but at the moment I am almost sure that it's caused by that the older version of postgis in the stored database. What is a kind of mystery for me that data in several tables were not restored, although the table definitions did (it means that I got several tables without data) althoug the data are there in the backup file (I checked physically). I really don't understand what's going on there, I did the same many times before, without any problem. Tomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] citing postgresql
I meant something for use in publications, like it is used for R and almost identically for GRASS: R Development Core Team (2008). R: A language and environment for statistical computing. R Foundation for Statistical Computing, Vienna, Austria. ISBN 3-900051-07-0, URL http://www.R-project.org. A BibTeX entry for LaTeX users is @Manual{, title = {R: A Language and Environment for Statistical Computing}, author = {{R Development Core Team}}, organization = {R Foundation for Statistical Computing}, address = {Vienna, Austria}, year = {2008}, note = {{ISBN} 3-900051-07-0}, url = {http://www.R-project.org}, } I changed the subject BTW. First time I sent this message to the list it was from my another account, not subscribed here, so I just copied the text and instead the subject I copied an address ... I am exhausted, sorry ... :-) Regards 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 give me an advice? You can start by looking at the wikipedia entry. Not sure what you mean by citing the db. Are you looking at citing where it comes from, who makes it, what? It can be kinda tough to classify open source software... :) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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 summarized some tricks and tips, at least? > > > > many thanks in advance and regards > > If it's just one database, then use pg_dump > (http://www.postgresql.org/docs/current/static/app-pgdump.html > ) to create a database dump, then you can pipe it into psql: > > psql < /path/to/dumpfile. > > or use pg_restore > (http://www.postgresql.org/docs/current/static/app-pgrestore.html). > > If you want to move the whole system, use pg_dumpall to dump > all databases. > > http://www.postgresql.org/docs/current/static/app-pg-dumpall.html > > -- > Postgresql & php tutorials > http://www.designmagick.com/ Thanks. No complications due the move to the higher version (8.2)? Tomas ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[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" for writing: Permission denied SQL state: 42501 What's wrong? Does it mean that the database user has no writing permission out of the database? How I did a pg_dump then few weeks ago? Many thanks for help and/or explanation, best regards and Happy New Year Tomas ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[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)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[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 the installer tried to create an acocunt, but than it gave an errormessage that the account already exists and the installation rolled back. Do somebody have a similar problem or do have somebody a suggestion what to do? Can I somehow remove this account? Thank You in advance Tomas ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster