Pavel Arnost wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5768
> Logged by: Pavel Arnost
> Email address: pavel.arn...@loutka.cz
> PostgreSQL version: 9.01
> Operating system: N/A
> Description:Inefficiency of large offsets should be mention
"David Quinn-Jacobs" writes:
> Causes connection failure. To re-create:
> CREATE TABLE Local ( foo TEXT );
> CREATE TABLE Remote ( bar TEXT );
> CREATE VIEW DblinkBugView AS
> SELECT * FROM Local L
> LEFT OUTER JOIN dblink( 'hostname=123.456.789.012
> dbname=a_longish_databa
The following bug has been logged online:
Bug reference: 5775
Logged by: David Quinn-Jacobs
Email address: d...@ecornell.com
PostgreSQL version: 9.0.1
Operating system: Cent OS 5
Description:DBLINK Connection String Truncation
Details:
Causes connection failure. To
Excerpts from Balamurugan Mahendran's message of lun nov 29 13:48:43 -0300 2010:
> Thanks, I'll remove it. But I still get down time because of Vacuum(table
> lock). Is there any other better way to do this? I don't mind to switch to
> bigger instance with more Hardware.
I wonder if you're doing s
queej writes:
> On Nov 29, 10:50 am, d...@authentrics.com (queej) wrote:
>> Yes, it causes an error for me since it truncates the connection string in
>> the middle of the username, omitting the password altogether. I must be
>> missing something; I can't understand what my alternative is but to
Is there a recommended link/documentation to make sure my configuration? for
my current hardware
7 GB of memory
20 EC2 Compute Units (8 virtual cores with 2.5 EC2 Compute Units each)
1690 GB of instance storage
64-bit platform
Thanks for all your help!!
Thanks,
Bala
On Mon, Nov 29, 2010 at 10:
Thanks, I'll remove it. But I still get down time because of Vacuum(table
lock). Is there any other better way to do this? I don't mind to switch to
bigger instance with more Hardware.
Current Instance :
7 GB of memory
20 EC2 Compute Units (8 virtual cores with 2.5 EC2 Compute Units each)
1690 GB
On Nov 29, 10:50 am, d...@authentrics.com (queej) wrote:
> Yes, it causes an error for me since it truncates the connection string in
> the middle of the username, omitting the password altogether. I must be
> missing something; I can't understand what my alternative is but to call the
> dblink(te
On 29.11.2010 18:48, Balamurugan Mahendran wrote:
Thanks, I'll remove it. But I still get down time because of Vacuum(table
lock). Is there any other better way to do this?
Non-full vacuum doesn't lock out concurrent access. If you're getting
downtime, there's got to be some other explanation.
On 29.11.2010 17:16, Balamurugan Mahendran wrote:
This is how I used to do maintenance through cron job. Please advise if i
need to change my method, Also I used to run re-index all the time while
doing Vacuum (cron job updated twice a week).
Most likely you can just remove the reindex commands
This is how I used to do maintenance through cron job. Please advise if i
need to change my method, Also I used to run re-index all the time while
doing Vacuum (cron job updated twice a week).
queryfor Vaccum:VACUUM VERBOSE ANALYZE contactmanagementsystem.brands
queryfor Vaccum:VACUUM VERBOSE ANAL
Yes, it causes an error for me since it truncates the connection string in
the middle of the username, omitting the password altogether. I must be
missing something; I can't understand what my alternative is but to call the
dblink(text,text) function with a connection string and a SQL statement.
On Mon, Nov 29, 2010 at 8:02 AM, Mohammed Rashad
wrote:
>
> I am running ubuntu 10.04
> I have problem installing postgresql-8.4
> when i tried to start postgresql
> /etc/init.d/postgresql-8.4 start
> I am getting this error
> * Starting PostgreSQL 8.4 database server
>
Hello Mohammed,
Mohammed Rashad [2010-11-29 20:50 +0530]:
> I reinstalled the postgresql and got this error
> * Starting PostgreSQL 8.4 database server
>* Insecure directory in $ENV{PATH} while running with -T switch at
> /usr/bin/pg_ctlcluster line 63.
This is not an upstream bug at all. Ca
Adrian Klaver wrote:
> On Monday 29 November 2010 7:02:46 am Mohammed Rashad wrote:
>> /etc/init.d/postgresql-8.4 start
> Are you trying to start Postgres as root? If so Postgres will not
> run as root,
> you will need to start it as the Postgres superuser, usually that
> is postgres.
Servi
I reinstalled the postgresql and got this error
* Starting PostgreSQL 8.4 database server
* Insecure directory in $ENV{PATH} while running with -T switch at
/usr/bin/pg_ctlcluster line 63.
On Mon, Nov 29, 2010 at 8:43 PM, Kevin Grittner wrote:
> Mohammed Rashad wrote:
>
> > I am getting th
Mohammed Rashad wrote:
> I am getting this error
>
> * Starting PostgreSQL 8.4 database server
> * Error: could not exec
> /usr/lib/postgresql/8.4/bin/pg_ctl
> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
> /var/lib/postgresql/8.4/main -l
> /var/log/postg
On Monday 29 November 2010 7:02:46 am Mohammed Rashad wrote:
> I am running ubuntu 10.04
> I have problem installing postgresql-8.4
>
> when i tried to start postgresql
> /etc/init.d/postgresql-8.4 start
>
> I am getting this error
>
> * Starting PostgreSQL 8.4 database server
>
I am running ubuntu 10.04
I have problem installing postgresql-8.4
when i tried to start postgresql
/etc/init.d/postgresql-8.4 start
I am getting this error
* Starting PostgreSQL 8.4 database server
* Error: could not exec
/usr/lib/postgresql/8.4/bin/pg_c
On 29.11.2010 14:36, Maharaja Subramanian wrote:
Hi,
Currently we have migrated from TWS/WebAdmin 8.1 version to TWS/WebAdmin 8.5.
Earlier in TWS/WebAdmin 8.1, we had utility called - psql located at
(/opt/maestro/webadmin/pgsql/bin). With this PSQL utility we used to connect to
TWS database
Hi,
Currently we have migrated from TWS/WebAdmin 8.1 version to TWS/WebAdmin 8.5.
Earlier in TWS/WebAdmin 8.1, we had utility called - psql located at
(/opt/maestro/webadmin/pgsql/bin). With this PSQL utility we used to connect to
TWS database where we can fire some SELECT queries and extract t
On Mon, Nov 22, 2010 at 03:41:06PM +, Joaquim Salles wrote:
> In oracle I have:
>
> EXEC SQL BEGIN DECLARE SECTION;
>
> typedef struct _SItemInfo
> {
> varchar strNome [40 +1];
>
> SItemInfo};
This seems to have the order reversed. Shouldn't it be
} SItemInfo; ?
> EXEC SQL SELE
Full Text index is not using during OR operation for multiple table join:
explain
SELECT crmentity.crmid, crmentity.setype, crmentity.modifiedtime,
activity.subject,case when ( users.user_name not like '') then
users.user_name else groups.groupname end as user_name, activity.date_start
FROM crmenti
23 matches
Mail list logo
