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 exis
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 i
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 PostGI
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.
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 userna
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 cod
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
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 custo
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: R
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
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 wor
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)
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 ($PGDA
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 ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ERRO
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
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 dat
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 cus
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) projec
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 sta
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
+-+---
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%20Es
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
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
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 op
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
Pos
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 applicati
=?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 12
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 distribu
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: syn
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 us
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.
>
> Post
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
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
= ?";
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
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
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 im
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 i
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 speci
Hi, friends.
Are there any performance tuning resouces for postgreSQL recommended, such
as ppt, books or articles?
Thanks!
peng
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
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
*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.2
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
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
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 Debi
45 matches
Mail list logo
