Re: [GENERAL]
On 25/10/11 14:17, wrote: > Hi,friends. > Please tell me how to build a debian package in detail,I would like > to build a debian package for postgreSQL. Why? To get a good answer, you will need to explain more about what you are trying to achieve and why you want it. There are already Debian packages for PostgreSQL. What is wrong with them? Do you want to build a package of a newer PostgreSQL for an older version of Debian/Ubuntu? If so, check backports.org before trying to build your own. If there isn't a backport to the version you want, I recommend that you get the source to the latest package for the latest debian release and backport that yourself rather than trying to make a new package from scratch. Do you actually want to *compile* an existing Debian package of PostgreSQL from source into a binary .deb? If so, use dpkg-build . -- Craig Ringer -- 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]
On 10/24/11 11:17 PM, 飞机 wrote: Please tell me how to build a debian package in detail,I would like to build a debian package for postgreSQL. http://lmgtfy.com?q=how+to+build+debian+package -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL]
Hi,friends. Please tell me how to build a debian package in detail,I would like to build a debian package for postgreSQL. Thanks! fei
Re: [GENERAL] Primary key Index Error
*Server log* Oct 1 00:06:59 server_host_name postgres[1453]: [5-1] 2011-10-01 00:06:59.831 EDT 1453 4e869041.5ad postgres [local] postgres LOG: duration: 418583.238 ms statement: select pg_start_backup('fortnightly'); Oct 2 03:03:18 server_host_name postgres[1453]: [6-1] 2011-10-02 03:03:18.243 EDT 1453 4e869041.5ad postgres [local] postgres LOG: duration: 8034.385 ms statement: select pg_stop_backup(); In between stop and start process server_host_name is receiving all type of DML & DDL and generating new WAL file Taking base backup in between start and stop process /*Client Log Details*/ Oct 25 05:16:18 client_server_name postgres[28858]: [2-1] 2011-10-25 05:16:18.202 BST 28858 LOG: could not open file "pg_xlog/271047B1008C" (log file 18353, segment 140): No such file or directory Oct 25 05:16:18 client_server_name postgres[28858]: [3-1] 2011-10-25 05:16:18.203 BST 28858 LOG: invalid checkpoint record Oct 25 05:16:18 client_server_name postgres[28858]: [4-1] 2011-10-25 05:16:18.203 BST 28858 FATAL: could not locate required checkpoint record Oct 25 05:16:18 client_server_name postgres[28858]: [4-2] 2011-10-25 05:16:18.203 BST 28858 HINT: If you are not restoring from a backup, try removing the file "/mnt/new_cluster/backup_label". Oct 25 05:16:18 client_server_name postgres[28857]: [1-1] 2011-10-25 05:16:18.205 BST 28857 LOG: startup process (PID 28858) exited with exit code 1 Oct 25 05:16:18 client_server_name postgres[28857]: [2-1] 2011-10-25 05:16:18.205 BST 28857 LOG: aborting startup due to startup process failure Oct 25 05:20:53 client_server_name postgres[29030]: [2-1] 2011-10-25 05:20:53.630 BST 29030 LOG: could not open file "pg_xlog/271047B10068" (log file 18353, segment 104): No such file or directory Oct 25 05:20:53 client_server_name postgres[29030]: [3-1] 2011-10-25 05:20:53.630 BST 29030 FATAL: could not find redo location referenced by checkpoint record Oct 25 05:20:53 client_server_name postgres[29030]: [3-2] 2011-10-25 05:20:53.630 BST 29030 HINT: If you are not restoring from a backup, try removing the file "/mnt/new_cluster/backup_label". Oct 25 05:20:53 client_server_name postgres[29029]: [1-1] 2011-10-25 05:20:53.633 BST 29029 LOG: startup process (PID 29030) exited with exit code 1 Oct 25 05:20:53 client_server_name postgres[29029]: [2-1] 2011-10-25 05:20:53.633 BST 29029 LOG: aborting startup due to startup process failure manually copy following file to pg_xlog folder 271047B1008C 271047B10068 After words i can start postgres and accessing the database , but same error -- View this message in context: http://postgresql.1045698.n5.nabble.com/Primary-key-Index-Error-tp4931714p4935172.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Re: [GENERAL] hi, friends. are there any performance tuning materials for postgreSQL recommended?
On 25/10/11 11:00, sunpeng wrote: > Hi, friends. > Are there any performance tuning resouces for postgreSQL recommended, > such as ppt, books or articles? > Thanks! > peng http://wiki.postgresql.org/wiki/Performance_Optimization http://www.postgresql.org/docs/books/ ... of which the most recent I know of is: http://www.postgresql.org/about/news.1249 -- Craig Ringer
Re: [GENERAL] [pgadmin-support] Help for Migration
On 25/10/11 03:36, Alban Hertroys wrote: > On 24 Oct 2011, at 14:24, wrote: > >> Hi , >> >> I have migrated Sql Server 2005 database to PostgreSQL 9.0 . I was also >> successfully able to connect classic ASP to the migrated database. But when >> the page reaches a stage where it is accessing a procedure I get the >> following error. >> >> PostgreSQL Native Provider error '80040e14' >> >> ERROR: syntax error at or near "' 789500'" LINE 1: EXEC Visadetailinsert ' >> 789500','No','Select visa','','','Se... ^ What database access driver/method are you using? PostgreSQL doesn't support 'EXEC' ... you probably want to SELECT myfunctionname(argument1, argument2); instead. If you're using ODBC, you should be using the ODBC procedure-call escape sequence to make it database-agnostic, eg: {? = CALL procname(?,?)} See: http://msdn.microsoft.com/en-us/library/ms403294.aspx The ODBC driver for the database you're using should translate that into suitable call syntax for your database, eg in PostgreSQL it should produce SELECT procname(?,?); and capture the result. I was initially suspicious that the issue was the whitespace in the quoted number, but that's not it. You're simply sending a completely bogus query string, and that's the first point the parser happens to choke on. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] hi, friends. are there any performance tuning materials for postgreSQL recommended?
Hi, friends. Are there any performance tuning resouces for postgreSQL recommended, such as ppt, books or articles? Thanks! peng
Re: [GENERAL] PostGIS in a commercial project
On 22/10/11 02:53, Eduardo Morras wrote: > At 09:26 21/10/2011, Thomas Kellerer wrote: >> Hello, >> >> we are using PostgreSQL in our projects and would like to integrate >> PostGIS as well. >> >> Now PostGIS is licensed under the GPL and I wonder if we can use it in >> a commercial (customer specific) project then. >> The source code will not be made open source, but of course the >> customer will get the source code. >> >> Is it still OK to use the GPL licensed PostGIS in this case? >> Is that then considered a derivative work because the application will >> not work without PostGIS? > > If it's pure GPL, then postgresql is automagically relicenced to GPL, > because postgresql allows relicencing and GPL force it to be GPL. Your > source code must be in GPL too. Remember, it's a virus licence and has > the same problem that Midas king had. I meant to reply to this earlier, but was hoping you meant it as a joke given the Midas reference. Your statement is incorrect. PostgreSQL is not "relicensed" to GPL in any way. GPL requirements are transitive, sure, but they don't *change* the license of linked code, they just require you to distribute it under terms compatible with the GPL which in practice means no more restrictive than the GPL. Note the NUMEROUS CLOSED SOURCE COMMERCIAL TOOLS THAT WORK WITH PostGIS. Were your statement true, they would not be possible. Notably, linking PostGIS to the PostgreSQL server can have no effect on the terms of use or license of libpq, let alone separately distributed adapters like PgODBC, PgJDBC (which doesn't even use libpq!) etc, or on programs using PostgreSQL via those adapters. Again, I strongly recommend that the original poster ask the PostGIS people about this, rather than relying on speculation from people who don't specialise in licensing (myself included) or work on/with a GPL project themselves. The PostGIS folks will get this question a lot, so much so that I'm astounded there doesn't seem to be anything in the FAQ about it. They'll certainly have a good answer if you ask them on their mailing list or via irc://chat.freenode.net/postgis . You can see on the commercial support projects list here (http://www.refractions.net/products/postgis/support/) that there are projects using PostGIS in commercial, closed-source settings. Personally, I think it'd be _very_ helpful if you did publish source code, even if it were under a more restrictive license that (say) prevents its commercial use. I get really frustrated when I have to work with products I don't have source code and debug binaries for. [Yes, Adobe, I'm looking at you and your buggy products.] That said, I see no evidence of any *obligation* to do so and plenty of evidence that theres' no such obligation. The lesson here: for licensing questions, don't ask a mailing list full of people who aren't even part of the project whose license you're interested in. -- Craig Ringer -- 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] Can someone help explain what's going on from the attached logs?
On 19/10/11 01:39, Samuel Hwang wrote: > The log is getting from PostgreSQL 9.0.4 > Basically we set up streaming replication hot-standby slave while master > is under heavy load > The slave started but not accepting read-only queries, > every request will trigger the "FATAL: the database system is starting > up" error. > > The slave will eventually be able to accept read-only queries after the > load on master is removed. > We don't see the same problem if we set up hot-standby slave while > master is not under heavy load. It sounds like the standby isn't becoming ready to accept connections until it first catches up with the master, consuming all available WAL segments. If this never happens, it never starts accepting connections. I'm not sure if that's by design or not and if there's any reason it's that way. Perhaps someone more familiar with recovery can explain? -- Craig Ringer -- 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] Help with copy (loading TSV file into table as text)
On 24/10/2011 22:39, Allan Kamau wrote: > On Mon, Oct 24, 2011 at 11:29 PM, Raymond O'Donnell wrote: >> On 24/10/2011 20:23, Allan Kamau wrote: >>> Hi, >>> I have a tab delimited file with over a thousand fields (columns) >>> which I would like to import into postgreSQL. >>> >>> I have opted to import the entire record (line) of this file into a >>> single field in a table, one table record per file line. Later split >>> the contents of the field accordingly into an array for further >>> processing and decomposition. >>> >>> I am using the COPY command as follows >>> #COPY a.t(raw_data)FROM '/data/tmp/t.txt'; >>> >>> and it reports "ERROR: extra data after last expected column". >> >> I'd guess that there's a character in the input which PG is interpreting >> as a column delimiter. Use the WITH DELIMITER option to set the expected >> delimiter to something that won't appear in the input. >> >> Ray. >> >> >> -- >> Raymond O'Donnell :: Galway :: Ireland >> r...@iol.ie >> > > Yes PG senses the tab and assumes it to be a field delimiter. I have > now used the '=' character as my "csv" delimiter after grepping the > file on '=' and seeing no lines were returned. > > Out of curiosity, what would be the correct use of "FORMAT text" > option in COPY command. The command below does give me an error as > indicated in my previous email. > > COPY a.t(raw_data)FROM '/data/tmp/t.txt' FORMAT text; I honestly don't know - it looks fine to me. The docs suggest that it'd give an error on pre-9.0 Postgres; but you said you're on 9.1... . Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- 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] Help with copy (loading TSV file into table as text)
On Mon, Oct 24, 2011 at 11:29 PM, Raymond O'Donnell wrote: > On 24/10/2011 20:23, Allan Kamau wrote: >> Hi, >> I have a tab delimited file with over a thousand fields (columns) >> which I would like to import into postgreSQL. >> >> I have opted to import the entire record (line) of this file into a >> single field in a table, one table record per file line. Later split >> the contents of the field accordingly into an array for further >> processing and decomposition. >> >> I am using the COPY command as follows >> #COPY a.t(raw_data)FROM '/data/tmp/t.txt'; >> >> and it reports "ERROR: extra data after last expected column". > > I'd guess that there's a character in the input which PG is interpreting > as a column delimiter. Use the WITH DELIMITER option to set the expected > delimiter to something that won't appear in the input. > > Ray. > > > -- > Raymond O'Donnell :: Galway :: Ireland > r...@iol.ie > Yes PG senses the tab and assumes it to be a field delimiter. I have now used the '=' character as my "csv" delimiter after grepping the file on '=' and seeing no lines were returned. Out of curiosity, what would be the correct use of "FORMAT text" option in COPY command. The command below does give me an error as indicated in my previous email. COPY a.t(raw_data)FROM '/data/tmp/t.txt' FORMAT text; Allan. -- 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] Help with copy (loading TSV file into table as text)
On 24/10/2011 20:23, Allan Kamau wrote: > Hi, > I have a tab delimited file with over a thousand fields (columns) > which I would like to import into postgreSQL. > > I have opted to import the entire record (line) of this file into a > single field in a table, one table record per file line. Later split > the contents of the field accordingly into an array for further > processing and decomposition. > > I am using the COPY command as follows > #COPY a.t(raw_data)FROM '/data/tmp/t.txt'; > > and it reports "ERROR: extra data after last expected column". I'd guess that there's a character in the input which PG is interpreting as a column delimiter. Use the WITH DELIMITER option to set the expected delimiter to something that won't appear in the input. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] strange java query behaviour
Hi, I've got a quite strange situation. Below is a simple test @Test public void test() throws SQLException { String query1 = "SELECT * FROM information_schema.schemata WHERE schema_name = ?"; String query2 = "SELECT * FROM pg_catalog.pg_namespace where nspname = ?"; check(query1, "1", "public"); check(query2, "2", "public"); } private void check(final String query, final String info, final String param) throws SQLException { PreparedStatement stmt = connection.prepareStatement(query); stmt.setString(1, param); ResultSet schemas = stmt.executeQuery(); boolean exists = schemas.next(); System.out.println(info + " : " + exists); } The output is: 1 : false 2 : true When I query the database using psql, both queries return sensible data (even when I prepare statements in postgres). I'd like to use information_schema rather than using pg_catalog. ENV: Ubuntu 11.10 PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46), 64-bit java version "1.6.0_26" Java(TM) SE Runtime Environment (build 1.6.0_26-b03) Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed mode) 9.0-801.jdbc4 regards Szymon
[GENERAL] Help with copy (loading TSV file into table as text)
Hi, I have a tab delimited file with over a thousand fields (columns) which I would like to import into postgreSQL. I have opted to import the entire record (line) of this file into a single field in a table, one table record per file line. Later split the contents of the field accordingly into an array for further processing and decomposition. I am using the COPY command as follows #COPY a.t(raw_data)FROM '/data/tmp/t.txt'; and it reports "ERROR: extra data after last expected column". #COPY a.t(raw_data)FROM '/data/tmp/t.txt' WITH FORMAT text; yields "ERROR: syntax error at or near "FORMAT" I am running PostgreSQL 9.1.1 compiled from source and deployed on Fedora Core 14 64bit. Below is the output of version(); m=> SELECT VERSION(); version -- PostgreSQL 9.1.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.5 20101112 (Red Hat 4.4.5-2), 64-bit (1 row) Allan. -- 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] [pgadmin-support] Help for Migration
On 24 Oct 2011, at 14:24, wrote: > Hi , > > I have migrated Sql Server 2005 database to PostgreSQL 9.0 . I was also > successfully able to connect classic ASP to the migrated database. But when > the page reaches a stage where it is accessing a procedure I get the > following error. > > PostgreSQL Native Provider error '80040e14' > > ERROR: syntax error at or near "' 789500'" LINE 1: EXEC Visadetailinsert ' > 789500','No','Select visa','','','Se... ^ > > /postgresql/EmployeeDetails.asp, line 645 Is that a line in a plpgsql procedure? It looks like you're trying to call a function, but your syntax is entirely wrong. You probably want to read up on: http://www.linuxtopia.org/online_books/database_guides/Practical_PostgreSQL_database/PostgreSQL_x20238_004.htm Curiously enough the rather fine manual isn't very verbose on this subject. In the 9.2-devel docs there is even a section named "Calling functions", but it seems to focus on writing functions instead. Alban Hertroys -- The scale of a problem often equals the size of an ego. -- 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] PostGIS in a commercial project
Tomas Vondra wrote on 24.10.2011 20:11: On 24 Říjen 2011, 19:44, Thomas Kellerer wrote: Pavel Stehule wrote on 24.10.2011 12:19: there is not clean who is customer and what is one unit. If you distribute PostGIS inside your application as one unit to customer, then your application should to use GPL. So if we only distribute our application and require the customer to install Postgres and PostGIS, then it shold be fine? I think you should actually read GPL license, because you're obviously confused by how it works - especially note the notion of "derived work". Derived work means that you take a GPL licensed software and modify it. In this case you're required to distribute the source code (again under GPL) to those who received the binary (legally). In case of PostGIS this would mean you modify the PostGIS source code itself, which is very unlikely I guess. Thanks. My understanding of "derived work" was, that anything that was "compiled" against a GPL licensed piece of software and thus will *only* run with that software is considered "derived". If derived work only applies to changes of the original software, then this is of course no problem. Regards Thomas -- 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] [pgadmin-support] Help for Migration
Hi , I have migrated Sql Server 2005 database to PostgreSQL 9.0 . I was also successfully able to connect classic ASP to the migrated database. But when the page reaches a stage where it is accessing a procedure I get the following error. PostgreSQL Native Provider error '80040e14' ERROR: syntax error at or near "' 789500'" LINE 1: EXEC Visadetailinsert ' 789500','No','Select visa','','','Se... ^ /postgresql/EmployeeDetails.asp, line 645 Where as the object is in valid state when seen from Pgadmin. Kindly advice what I should check next to resolve this issue. Thanks, Mamatha -- 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] PostGIS in a commercial project
On 24 Říjen 2011, 19:44, Thomas Kellerer wrote: > Pavel Stehule wrote on 24.10.2011 12:19: >> there is not clean who is customer and what is one unit. If you >> distribute PostGIS inside your application as one unit to customer, >> then your application should to use GPL. > > So if we only distribute our application and require the customer to > install Postgres and PostGIS, then it shold be fine? I think you should actually read GPL license, because you're obviously confused by how it works - especially note the notion of "derived work". Derived work means that you take a GPL licensed software and modify it. In this case you're required to distribute the source code (again under GPL) to those who received the binary (legally). In case of PostGIS this would mean you modify the PostGIS source code itself, which is very unlikely I guess. Also note that you're not required to provide the sources to whoever asks, only to those who received the binary from you. If someone "steals" the software or receives the software from someone else, you're safe. Anyway if you're going just to use PostGIS (without modifying it), neither of the previous requirements of the concern as your application does not need to be a GPL licensed. 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] Problem with newline/tab completing with psql
=?ISO-8859-1?Q?H=E5vard_Wahl_Kongsg=E5rd?= writes: > Hi, I have a problem with newline or tab completing when adding a > generated FUNCTION via the psql interface (have tried pasting and > adding it with -f rule.sql) > parser stack overflow at or near "THEN" > LINE 5002: ELSIF ( NEW.a between 1246566738 and 1247010220 ) THEN That's pretty interesting. Could we see a complete (self-contained) example of this problem, rather than a snippet? And what PG version is this exactly? Given that line number, though, I wonder whether your problem is that you tried to put several thousand nested IFs into one plpgsql function. If so, the answer is probably "refactor your code". You *will* eventually hit this type of error if you nest stuff deeply enough. I don't know exactly where the limit is, and it probably varies a lot depending on platform, PG version, etc etc anyway. regards, tom lane -- 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] PostGIS in a commercial project
2011/10/24 Thomas Kellerer : > Pavel Stehule wrote on 24.10.2011 12:19: >> >> there is not clean who is customer and what is one unit. If you >> distribute PostGIS inside your application as one unit to customer, >> then your application should to use GPL. > > So if we only distribute our application and require the customer to install > Postgres and PostGIS, then it shold be fine? I think so it's possible - Linux is GPL, but you can run a non GPL applications. Regards Pavel Stehule > > > > > -- > 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
Re: [GENERAL] PostGIS in a commercial project
Pavel Stehule wrote on 24.10.2011 12:19: there is not clean who is customer and what is one unit. If you distribute PostGIS inside your application as one unit to customer, then your application should to use GPL. So if we only distribute our application and require the customer to install Postgres and PostGIS, then it shold be fine? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Problem with newline/tab completing with psql
Hi, I have a problem with newline or tab completing when adding a generated FUNCTION via the psql interface (have tried pasting and adding it with -f rule.sql) parser stack overflow at or near "THEN" LINE 5002: ELSIF ( NEW.a between 1246566738 and 1247010220 ) THEN Have also tried using the -n option with psql and set disable-completion on in .inputrc Is there any other method to solve this problem? -- Håvard Wahl Kongsgård -- 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] PostGIS in a commercial project
2011/10/24 Edoardo Panfili : > Il 24/10/11 10:03, Pavel Stehule ha scritto: >> >> 2011/10/24 Thomas Kellerer: >>> >>> Eduardo Morras, 21.10.2011 20:53: > > Now PostGIS is licensed under the GPL and I wonder if we can use it > in a commercial (customer specific) project then. The source code > will not be made open source, but of course the customer will get > the source code. > > Is it still OK to use the GPL licensed PostGIS in this case? Is > that then considered a derivative work because the application will > not work without PostGIS? If it's pure GPL, then postgresql is automagically relicenced to GPL, because postgresql allows relicencing and GPL force it to be GPL. Your source code must be in GPL too. Remember, it's a virus licence and has the same problem that Midas king had. >>> >>> Thanks for the answer. >>> >>> I think we'll better be safe than sorry and we will not use PostGIS then. >> >> It doesn't mean, so you must to publish your source code on net. Your >> codes have to be available to your customers. That is all. You can >> distribute your product as service, and then you don't need to show >> your codes. >> > > I am developing a web system that uses postgres and postgis, my source code > is released under Apache2 licence (The customers has a copy of the whole > source reposotory). The server interacts using jdbc and a C function for > postgres. The client (java) interacts only with my server application. > > I think that this is safe, I'm doing wrong? > My software has to use the GPL? if I can I'd like to use Apache2 licence for > my source code. there is not clean who is customer and what is one unit. If you distribute PostGIS inside your application as one unit to customer, then your application should to use GPL. Pavel > > > Regards > Edoardo > > -- > 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
Re: [GENERAL] Primary key Index Error
On Mon, Oct 24, 2011 at 3:22 AM, Manoj K P wrote: > Postgres recovered from data folder , after that some queries shows error > > > select * from table2 order by app_id ; - its work ( 5000 data) > select * from table2 order by app_id desc ; - its work > > Here app_id contains binary index > > > select * from table2 order by id ; - its work ( 5000 data) > select * from table2 order by id desc ; - shows following error > > manoj[local] postgres ERROR: index "tbl2_id_pkey" contains unexpected zero > page at block 311121 > manoj [local] postgres HINT: Please REINDEX it. > > index "tbl2_id_pkey" is primary key > > Reindex not pratical this table (250 GB data) > > How i can solve this ? It looks like you have data corruption. Your first priority should be to do the minimum necessary to get a usable database dump and then to get back online. I would consider your database off line until this is done. Essentially, the only practical ways to repair the error you see would be to reindex or restore from backup. Did you have any unexpected power events? Server crashes? merlin -- 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] Error inserting RFC1738-encoded URLs
On Mon, Oct 24, 2011 at 10:27, Javier Amor garcia wrote: > sometimes I get encoding errors when inserting a s a encoded URL in a text > field. You forgot the most important thing: *What's* the error that you get? > http://www.formacion.aimplas.es/_Documentos/2011/FORMACIÓN%20ABIERTA/Folleto%20Especialistas%20Universitarios%20Polímeros%20ok.pdf Since I have to guess, I suspect you're sending these strings to Postgres in a non-UTF-8 encoding. This isn't a valid URL anyway -- you can't have unquoted "Ó" or "í" characters since they're not valid ASCII. But a 'varchar' field would accept them anyway if you send them in the right encoding. Regards, Marti -- 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] Adding a unique number to each record in a table
On 10/24/2011 11:19 AM, Alexander Farber wrote: Hello, I have a table in PostgreSQL 8.4.9 storing user comments (in the "about" field): # \d pref_rep Table "public.pref_rep" Column |Type | Modifiers +-+--- id | character varying(32) | author | character varying(32) | good | boolean | fair | boolean | nice | boolean | about | character varying(256) | last_rated | timestamp without time zone | default now() author_ip | inet| Check constraints: "pref_rep_check" CHECK (id::text<> author::text) Foreign-key constraints: "pref_rep_author_fkey" FOREIGN KEY (author) REFERENCES pref_users(id) "pref_rep_id_fkey" FOREIGN KEY (id) REFERENCES pref_users(id) But now after having 4 comments I've realized, that I need a web script for me as admin - for delete obscene/aggressive ones. Because doing it thru "psql" is tedious + error prone. Is there please a way to add a column to my table, which I could use to uniquely identify each record in that table (incl. old records) Regards Alex alter table pref_rep add rowid serial; Will both add the column and set it for existing rows, as well as for new rows. -Andy -- 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] how to enable ldap authentication
bo gu writes: > It seemed the executable was compiled with ldap: > ldd /usr/local/pgsql/bin/postgres > libldap-2.2.so.7 => /usr/lib64/libldap-2.2.so.7 (0x002a956ed000) > < I agree, that executable looks to have ldap support. > But when I ran pg_ctl start, it exits without listening any port and I got > this: > tail postgresql-2011-10-24_104954.log > LOG: invalid authentication method "ldap": not supported by this build > CONTEXT: line 97 of configuration file > "/usr/local/pgsql/databases/tudouapi/pg_hba.conf" But this one doesn't. Are you sure you invoked /usr/local/pgsql/bin/postgres, and not some other copy? regards, tom lane -- 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] PostGIS in a commercial project
Il 24/10/11 12:19, Pavel Stehule ha scritto: 2011/10/24 Edoardo Panfili: Il 24/10/11 10:03, Pavel Stehule ha scritto: 2011/10/24 Thomas Kellerer: Eduardo Morras, 21.10.2011 20:53: Now PostGIS is licensed under the GPL and I wonder if we can use it in a commercial (customer specific) project then. The source code will not be made open source, but of course the customer will get the source code. Is it still OK to use the GPL licensed PostGIS in this case? Is that then considered a derivative work because the application will not work without PostGIS? If it's pure GPL, then postgresql is automagically relicenced to GPL, because postgresql allows relicencing and GPL force it to be GPL. Your source code must be in GPL too. Remember, it's a virus licence and has the same problem that Midas king had. Thanks for the answer. I think we'll better be safe than sorry and we will not use PostGIS then. It doesn't mean, so you must to publish your source code on net. Your codes have to be available to your customers. That is all. You can distribute your product as service, and then you don't need to show your codes. I am developing a web system that uses postgres and postgis, my source code is released under Apache2 licence (The customers has a copy of the whole source reposotory). The server interacts using jdbc and a C function for postgres. The client (java) interacts only with my server application. I think that this is safe, I'm doing wrong? My software has to use the GPL? if I can I'd like to use Apache2 licence for my source code. there is not clean who is customer and what is one unit. If you distribute PostGIS inside your application as one unit to customer, then your application should to use GPL. Customer: a research group that uses a server application to store data plus a client application (pure java) that exchanges data with server application (not directly with postgres). I do not distribute postgres nor postgis inside my application. The customer installs postgres, postigis and then install my application (inside tomcat) and create the db. Other people downloads a java application that exchanges data with my application. Is not so easy manage licences (even though I read it) Postgres uses licence similar to BDS PostGIS uses GPL Tomcat uses Apache2 ...and an application usually uses othe libraries. But at the end my software does not use the source code of postgis (but uses postgres include files for a C function). Regard Edoardo -- 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] PostGIS in a commercial project
On Monday, October 24, 2011 12:31:16 am Thomas Kellerer wrote: > Eduardo Morras, 21.10.2011 20:53: > >> Now PostGIS is licensed under the GPL and I wonder if we can use it > >> in a commercial (customer specific) project then. The source code > >> will not be made open source, but of course the customer will get > >> the source code. > >> > >> Is it still OK to use the GPL licensed PostGIS in this case? Is > >> that then considered a derivative work because the application will > >> not work without PostGIS? > > > > If it's pure GPL, then postgresql is automagically relicenced to GPL, > > because postgresql allows relicencing and GPL force it to be GPL. > > Your source code must be in GPL too. Remember, it's a virus licence > > and has the same problem that Midas king had. > > Thanks for the answer. > > I think we'll better be safe than sorry and we will not use PostGIS then. When in doubt read the source: http://www.opensource.org/licenses/gpl-2.0.php In particular sections 2 & 3. I see nothing that precludes you doing what you want. > > Regards > Thomas -- Adrian Klaver adrian.kla...@gmail.com -- 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] Primary key Index Error
On Mon, Oct 24, 2011 at 8:32 AM, manoj wrote: > On 10/24/2011 06:38 PM, Merlin Moncure wrote: > > On Mon, Oct 24, 2011 at 3:22 AM, Manoj K P wrote: > > Postgres recovered from data folder , after that some queries shows error > > > select * from table2 order by app_id ; - its work ( 5000 data) > select * from table2 order by app_id desc ; - its work > > Here app_id contains binary index > > > select * from table2 order by id ; - its work ( 5000 data) > select * from table2 order by id desc ; - shows following error > > manoj[local] postgres ERROR: index "tbl2_id_pkey" contains unexpected zero > page at block 311121 > manoj [local] postgres HINT: Please REINDEX it. > > index "tbl2_id_pkey" is primary key > > Reindex not pratical this table (250 GB data) > > How i can solve this ? > > It looks like you have data corruption. Your first priority should be > to do the minimum necessary to get a usable database dump and then to > get back online. I would consider your database off line until this > is done. Essentially, the only practical ways to repair the error you > see would be to reindex or restore from backup. Did you have any > unexpected power events? Server crashes? > > merlin > > Actually this is backup server ,no power failure & Server crashes happens > in between , The data folder is base backup(pg_start_backup) on the server. > pg_dump not practical in this case because of data size. > After recovering from base backup run WAL recovery file successfully and > its updates current date data. > When i am running query on big table(more than 5 Million data) shows > error other wise its work fine. > > select id , name from table2 order by id ; It uses the index > > select id , name from table2 order by id desc ; - shows the error > > Error happens only using (DESC clause against primary key) , all other case > its work fine > > REINDEX will take ages do you happen to still have the database logs on the backup from startup to end of recovery? anything interesting in there? merlin -- 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] Autentication exceptions in pgsql 8.3
On Mon, Oct 24, 2011 at 11:06, Prakash, Deepthi (NSN - IN/Bangalore) wrote: > Hello, > > > > How can I check that? Should I do any configurations in ident server? That depends on your ident server - I don't know those specifically. But yes, it should be configured to not do that if that's what it's doing. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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] Error inserting RFC1738-encoded URLs
Thanks for you reply Marti. I wil ltry to complete the description of the problem. I get errors like this: Error inserting data: INSERT INTO squid_access ( bytes, event, elapsed, rfc931, timestamp, url, method, peer, mimetype, remotehost, code) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ERROR: invalid byte sequence for encoding "UTF8": 0xe97469 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". I am sending the data to the database trough the DBI perl module, tomorrow I will make sure that the data is read as UTF8 but I think I had previously already tried to encode this a UTF8. (not sure, it was some weeks ago). Anyway, with the new data you continue to think the problem is that the data is sent with the bad encoding?. Regards, Javier On 10/24/2011 01:37 PM, Marti Raudsepp wrote: On Mon, Oct 24, 2011 at 10:27, Javier Amor garcia wrote: sometimes I get encoding errors when inserting a s a encoded URL in a text field. You forgot the most important thing: *What's* the error that you get? http://www.formacion.aimplas.es/_Documentos/2011/FORMACIÓN%20ABIERTA/Folleto%20Especialistas%20Universitarios%20Polímeros%20ok.pdf Since I have to guess, I suspect you're sending these strings to Postgres in a non-UTF-8 encoding. This isn't a valid URL anyway -- you can't have unquoted "Ó" or "í" characters since they're not valid ASCII. But a 'varchar' field would accept them anyway if you send them in the right encoding. Regards, Marti -- 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] Recovery from Archive files
On Thu, Oct 20, 2011 at 11:42 AM, Raghavendra wrote: > On Thu, Oct 20, 2011 at 11:58 PM, John R Pierce wrote: >> >> On 10/20/11 2:33 AM, Raghavendra wrote: >>> >>> Am assuming you are having $PGDATA (data directory) and their WAL >>> Archives. >> >> he said he does not have the base backup ($PGDATA), so this is pointless. > > Ahh.. Agreed. > I mis-read, I though he is trying to recovery from current DATA directory > and not with base backup which he doesn't have it. > --- > Regards, > Raghavendra > EnterpriseDB Corporation > Blog: http://raghavt.blogspot.com/ > > I thought if you had every log file ever generated from initdb, you could initdb, and start replaying logs? It's an odd scenario, but I thought I heard that could work... Come to think of it, I think that was an Oracle thing I heard... but still.. if you had every log file - Ian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Adding a unique number to each record in a table
Hello, I have a table in PostgreSQL 8.4.9 storing user comments (in the "about" field): # \d pref_rep Table "public.pref_rep" Column |Type | Modifiers +-+--- id | character varying(32) | author | character varying(32) | good | boolean | fair | boolean | nice | boolean | about | character varying(256) | last_rated | timestamp without time zone | default now() author_ip | inet| Check constraints: "pref_rep_check" CHECK (id::text <> author::text) Foreign-key constraints: "pref_rep_author_fkey" FOREIGN KEY (author) REFERENCES pref_users(id) "pref_rep_id_fkey" FOREIGN KEY (id) REFERENCES pref_users(id) But now after having 4 comments I've realized, that I need a web script for me as admin - for delete obscene/aggressive ones. Because doing it thru "psql" is tedious + error prone. Is there please a way to add a column to my table, which I could use to uniquely identify each record in that table (incl. old records) Regards Alex -- 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] Primary key Index Error
On 10/24/2011 06:38 PM, Merlin Moncure wrote: On Mon, Oct 24, 2011 at 3:22 AM, Manoj K P wrote: Postgres recovered from data folder , after that some queries shows error select * from table2 order by app_id ; - its work ( 5000 data) select * from table2 order by app_id desc ; - its work Here app_id contains binary index select * from table2 order by id ; - its work ( 5000 data) select * from table2 order by id desc ; - shows following error manoj[local] postgres ERROR: index "tbl2_id_pkey" contains unexpected zero page at block 311121 manoj [local] postgres HINT: Please REINDEX it. index "tbl2_id_pkey" is primary key Reindex not pratical this table (250 GB data) How i can solve this ? It looks like you have data corruption. Your first priority should be to do the minimum necessary to get a usable database dump and then to get back online. I would consider your database off line until this is done. Essentially, the only practical ways to repair the error you see would be to reindex or restore from backup. Did you have any unexpected power events? Server crashes? merlin Actually this is backup server ,no power failure& Server crashes happens in between , The data folder is base backup(|pg_start_backup)| on the server. pg_dump not practical in this case because of data size. After recovering from base backup run WAL recovery file successfully and its updates current date data. When i am running query on big table(more than 5 Million data) shows error other wise its work fine. select id , name from table2 order by id ; It uses the index select id , name from table2 order by id desc ; - shows the error Error happens only using (DESC clause against primary key) , all other case its work fine REINDEX will take ages -- *Manoj K P* *Postgres DBA* *Comodo India* smime.p7s Description: S/MIME Cryptographic Signature
Re: [GENERAL] : PostgreSQL Online Backup
Sorry for not responding to this email for so long. Alan, We had mentioned the following line in recovery.conf file (we had given pg_xlog location since we did not have WAL archives) - restore_command = 'cp /pg_xlog/%f %p' We found where the problem was - Here is what i did - 1. We had taken a full backup using pg_start_backup() and pg_stop_backup() on Day 1 2. Rest of the days (from Day 2 - Day 15), we had incrementally backed-up ( this is also using pg_start_backup() and pg_stop_backup()) 3. On Day-16th, when i started the recovery, PG was asking Day 1's WAL archive file, which we did not have. A fresh complete backup with change in our backup strategy resolved the issue. Thanks a lot for all your inputs and help on this !! Regards, VB 2011/10/4 Alan Hodgson > > > rsync works fine. Why exactly can't the recovery find the backed up > copy > > > of 000105390076? Please post your archive_command settings, > > > the contents of any script(s) called by that, and the recovery.conf > file > > > you're using that's having problems, as well as the complete process > you > > > followed to > > > initiate recovery. I strongly suspect you're missing part of the > process > > > of actually saving the WAL files needed for recovery. > > > The recovery is unable to find the WAL archive because, it was generated > on > > 26th September. > > > > Whereas the backup is as taken on Oct 2nd, 2011. We deleted all the > files. > > > > I do not have that WAL archive copy. > > > > The problem area - > > > > I found that a pg_clog file dated 26th Sep, 2011 is not synced (its not > > 256K). > > > > I'm going to need the rest of what I asked for to offer any further > suggestions > - especially the full and exact steps you took to initiate recovery and the > contents of recovery.conf. Also, please don't top-post. > > -- > 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] Autentication exceptions in pgsql 8.3
Hello, How can I check that? Should I do any configurations in ident server? Thanks and Regards, Deepthi From: ext Magnus Hagander [mailto:mag...@hagander.net] Sent: Monday, October 24, 2011 1:29 PM To: Prakash, Deepthi (NSN - IN/Bangalore) Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Autentication exceptions in pgsql 8.3 On Monday, October 24, 2011, Prakash, Deepthi (NSN - IN/Bangalore) wrote: Hello, I am using Postgresql 8.3, I am getting the below authentication exceptions. I am not able to connect using postgres://mpp:mpp@localhost/mpp LOG: provided username (mpp) and authenticated username ([U2FsdGVkX1/4XrEZ3dfREbh66kqWj66oEZjvotlVtqo=]) don't match FATAL: Ident authentication failed for user "mpp" LOG: provided username (mpp) and authenticated username ([U2FsdGVkX19aYlj8eW0BPmAZ4Loziuy64Urcd4ZhMOg=]) don't match This indicate that your auth server returned userid "[U2FsdGVkX19aYlj8eW0BPmAZ4Loziuy64Urcd4ZhMOg=]", which is obviously incorrect. Are you by any chance running with some sort of encryption/hashing in the ident server? That's not supported with PostgreSQL. If not that, then I'm not sure exactly what it could be - but it's obvious that your ident server is reporting an incorrect username, so you'll need to investigate that one. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/
Re: [GENERAL] PostGIS in a commercial project
Il 24/10/11 10:03, Pavel Stehule ha scritto: 2011/10/24 Thomas Kellerer: Eduardo Morras, 21.10.2011 20:53: Now PostGIS is licensed under the GPL and I wonder if we can use it in a commercial (customer specific) project then. The source code will not be made open source, but of course the customer will get the source code. Is it still OK to use the GPL licensed PostGIS in this case? Is that then considered a derivative work because the application will not work without PostGIS? If it's pure GPL, then postgresql is automagically relicenced to GPL, because postgresql allows relicencing and GPL force it to be GPL. Your source code must be in GPL too. Remember, it's a virus licence and has the same problem that Midas king had. Thanks for the answer. I think we'll better be safe than sorry and we will not use PostGIS then. It doesn't mean, so you must to publish your source code on net. Your codes have to be available to your customers. That is all. You can distribute your product as service, and then you don't need to show your codes. I am developing a web system that uses postgres and postgis, my source code is released under Apache2 licence (The customers has a copy of the whole source reposotory). The server interacts using jdbc and a C function for postgres. The client (java) interacts only with my server application. I think that this is safe, I'm doing wrong? My software has to use the GPL? if I can I'd like to use Apache2 licence for my source code. Regards Edoardo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Primary key Index Error
Postgres recovered from data folder , after that some queries shows error select * from table2 order by app_id ; - its work ( 5000 data) select * from table2 order by app_id desc ; - its work Here app_id contains binary index select * from table2 order by id ; - its work ( 5000 data) select * from table2 order by id desc ; - shows following error manoj[local] postgres ERROR: index "tbl2_id_pkey" contains unexpected zero page at block 311121 manoj [local] postgres HINT: Please REINDEX it. index "tbl2_id_pkey" is primary key Reindex not pratical this table (250 GB data) How i can solve this ? Regards Manoj K P -- View this message in context: http://postgresql.1045698.n5.nabble.com/Primary-key-Index-Error-tp4931714p4931714.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- 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] PostGIS in a commercial project
2011/10/24 Thomas Kellerer : > Eduardo Morras, 21.10.2011 20:53: >>> >>> Now PostGIS is licensed under the GPL and I wonder if we can use it >>> in a commercial (customer specific) project then. The source code >>> will not be made open source, but of course the customer will get >>> the source code. >>> >>> Is it still OK to use the GPL licensed PostGIS in this case? Is >>> that then considered a derivative work because the application will >>> not work without PostGIS? >> >> If it's pure GPL, then postgresql is automagically relicenced to GPL, >> because postgresql allows relicencing and GPL force it to be GPL. >> Your source code must be in GPL too. Remember, it's a virus licence >> and has the same problem that Midas king had. > > Thanks for the answer. > > I think we'll better be safe than sorry and we will not use PostGIS then. It doesn't mean, so you must to publish your source code on net. Your codes have to be available to your customers. That is all. You can distribute your product as service, and then you don't need to show your codes. Regards Pavel Stehule > > Regards > Thomas > > > > -- > 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
Re: [GENERAL] Autentication exceptions in pgsql 8.3
On Monday, October 24, 2011, Prakash, Deepthi (NSN - IN/Bangalore) wrote: > ** > > Hello, > > I am using Postgresql 8.3, I am getting the below authentication > exceptions.I am not able to connect > using postgres://mpp:mpp@localhost/mpp > > LOG: provided username (mpp) and authenticated username > ([U2FsdGVkX1/4XrEZ3dfREbh66kqWj66oEZjvotlVtqo=]) don't match > > FATAL: Ident authentication failed for user "mpp" > > LOG: provided username (mpp) and authenticated username > ([U2FsdGVkX19aYlj8eW0BPmAZ4Loziuy64Urcd4ZhMOg=]) don't match > This indicate that your auth server returned userid "[U2FsdGVkX19aYlj8eW0BPmAZ4Loziuy64Urcd4ZhMOg=]", which is obviously incorrect. Are you by any chance running with some sort of encryption/hashing in the ident server? That's not supported with PostgreSQL. If not that, then I'm not sure exactly what it could be - but it's obvious that your ident server is reporting an incorrect username, so you'll need to investigate that one. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/
Re: [GENERAL] PostGIS in a commercial project
Am 24/10/11 09:31, schrieb Thomas Kellerer: Eduardo Morras, 21.10.2011 20:53: Now PostGIS is licensed under the GPL and I wonder if we can use it in a commercial (customer specific) project then. The source code will not be made open source, but of course the customer will get the source code. so there is no reason not to use GPL'ed software. GPL-ed software does not mean you have to release everything to the public. It means you are not allowed to give it away without source code. to whom you give it is not ruled by the licence. but to whom you give it, the reciever is free to do with it as sHe pleases (within the licences restriction ..) robert Is it still OK to use the GPL licensed PostGIS in this case? Is that then considered a derivative work because the application will not work without PostGIS? If it's pure GPL, then postgresql is automagically relicenced to GPL, because postgresql allows relicencing and GPL force it to be GPL. Your source code must be in GPL too. Remember, it's a virus licence and has the same problem that Midas king had. Thanks for the answer. I think we'll better be safe than sorry and we will not use PostGIS then. Regards Thomas -- 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] PostGIS in a commercial project
Eduardo Morras, 21.10.2011 20:53: Now PostGIS is licensed under the GPL and I wonder if we can use it in a commercial (customer specific) project then. The source code will not be made open source, but of course the customer will get the source code. Is it still OK to use the GPL licensed PostGIS in this case? Is that then considered a derivative work because the application will not work without PostGIS? If it's pure GPL, then postgresql is automagically relicenced to GPL, because postgresql allows relicencing and GPL force it to be GPL. Your source code must be in GPL too. Remember, it's a virus licence and has the same problem that Midas king had. Thanks for the answer. I think we'll better be safe than sorry and we will not use PostGIS then. Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Error inserting RFC1738-encoded URLs
Hello, sometimes I get encoding errors when inserting a s a encoded URL in a text field. The database uses UTF8, with both collation and c-type defined as en_US.UTF-8, and the URL field itself is defined as VARCHAR(1024). In the case that the URL is longer than 1024 the software truncates it. The inserted URL is extracted from the log file of the Squid Proxy, which is encoded in UTF8. The URL is encoded with RFC 1738 encoding of all non-ASCII characters in the path & query sections. puny-coding of characters in the host authority section. RFC 1738 -> http://www.ietf.org/rfc/rfc1738.txt Example of URLs that raise error: http://www.formacion.aimplas.es/_Documentos/2011/FORMACIÓN%20ABIERTA/Folleto%20Especialistas%20Universitarios%20Polímeros%20ok.pdf http://ads.prisacom.com/RealMedia/ads/adstream_mjx.ads/www.elpais.es/edicionimpresa/deportes/articulos/1452867580@Middle,Middle1,Top,Top2,TopRight,x02,x20?search=VUELTA%20A%20ESPAÑA,Ciclismo,Deportes http://ads.prisacom.com/RealMedia/ads/adstream_nx.ads/www.elpais.es/edicionimpresa/deportes/articulos/1452867580@Middle,Middle1,Top,Top2,TopRight,x02,x20!Middle?search=VUELTA%20A%20ESPAÑA,Ciclismo,Deportes http://www.t-a-o.com/ES/moda-bebe-nino/pantalón/flash/zoom.swf?image_lien=52905_C1057_A_zoom.jpg&lang=ES http://static.slidesharecdn.com/swf/menu.swf?embedCode=%20http://www.slideshare.net/raimonesteve/que-es-openerp"%20title="¿Que%20es%20Openerp?"%20target="_blank";>¿Que%20es%20Openerp?%20http://www.slideshare.net/slideshow/embed_code/1320169"%20width="425"%20height="355"%20frameborder="0"%20marginwidth="0"%20marginheight="0"%20scrolling="no";>%20%20View%20more%20http://www.slideshare.net/"%20target="_blank";>presentations%20from%20http://www.slideshare.net/raimonesteve"%20target="_blank";>raimonesteve%20%20&showID=1320169&showURL=http://www.slideshare.net/raimonesteve/que-es-openerp End URL examples Anyone know what I must do to be able to safely insert any http URL?. Thanks for your time, Javier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Upgrading an existing database structure
Hello all, I am interested in knowing how to upgrade a database structure on an existing database. I have a script that creates and alters tables, columns and data. When this script is run, errors are thrown for already inserted tables, columns and data. Anything that is not found in the existing database is then executed. This prevents existing data to not be wiped out. Does anyone else have a better way of upgrading a database structure on an existing database? Thanking you in advance.