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
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
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
*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
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
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
Hi, friends.
Are there any performance tuning resouces for postgreSQL recommended, such
as ppt, books or articles?
Thanks!
peng
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
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 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 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 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
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
= ?";
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
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
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
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
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
=?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
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
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
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
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
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
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 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
+-+---
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
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
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
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 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
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 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
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 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
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
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
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
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
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
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
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.
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
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
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
45 matches
Mail list logo
