On 2009-11-16, Gauthier, Dave wrote:
> --_000_482E80323A35A54498B8B70FF2B87980042237CF64azsmsx504amrc_
> Content-Type: text/plain; charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> Hi:
>
> Is there a way to require and specify a password at the cmd line for a conn=
> ect? At fi
On 2009-11-17, Ashesh Vashi wrote:
> --000e0cd211e054ab9404788a05cf
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi Dave,
>
> You can always use the environment variable PGPASSWORD to do that.
> Though - it is not recommended to use for security reason. :(
as long as it's not in the default
Hi All,
I am facing the below error when executing "VACCUM ANALYZE" on the
several tables and also the entire PostgreSQL database hanging up and
not responding.
WARNING: worker took too long to start; cancelled
I am using PostgreSQL 8.3.5 on windows 32 bit machine.
Any help would be h
Hi all,
I know this is none of the user's business, but I'm wondering how
blob's implemented as oid are stored in the postgresql data storage.
Are each of them kept in a separate file, or are they chunked into
pieces and scattered ?
Thanks !
Jerome.
--
Jerome Eteve.
http://www.eteve.net
jer...
Great pages!
Thanks for sharing this.
J.
2009/11/26 Craig Ringer :
> Craig Ringer wrote:
>> Hi folks
>>
>> Since it seems to come up a lot, I've added some info on the pitfalls of
>> VACUUM FULL to the wiki:
>>
>> http://wiki.postgresql.org/index.php?title=VACUUM_FULL
>
> Similarly, a page on to
Hi Folks,
I am frequently getting read-only file system error on my server.
We are using postgreSQL, GridSQL database. The size of database is very huge.
Architecture Details:
CentOS 5.3 64 bit Areca high point rocket raid 3520 8 port
32 GB RAM
assemble hardware
We are daily processing mill
On Thu, Nov 26, 2009 at 1:40 PM, Sam Jas wrote:
> Hi Folks,
>
> I am frequently getting read-only file system error on my server.
>
> We are using postgreSQL, GridSQL database. The size of database is very
> huge.
> Architecture Details:
> CentOS 5.3 64 bit Areca high point rocket raid 3520 8 por
How can i enable journaling as i am not so good at OS & H/W level. Can you give
me some detail description.
Thanks
Sam Jas
--- On Thu, 26/11/09, Grzegorz Jaśkiewicz wrote:
From: Grzegorz Jaśkiewicz
Subject: Re: [GENERAL] READ ONLY & I/O ERROR
To: "Sam Jas"
Cc: pgsql-general@postgresql.or
Is there any other processes running over the same system
like antivirus or similar software on the machine?
Have you changed any configuration parameters around the memory size such as
shared_buffers?
--
Thanks
Sam Jas
--- On Thu, 26/11/09, a.bhattacha...@sungard.com
wrote:
From: a.
2009/11/26 Sam Jas
> How can i enable journaling as i am not so good at OS & H/W level. Can you
> give me some detail description.
>
>
a) don't top post,
b) don't send emails in html,
c) man e2fsck , I am sure it is described all around net million times. it
is something I haven't done in a while
oh, and fourth - if you get filesystem errors, I would inspect drives, raid
card, etc - because those usually mean that something's fishy.
Is there anyone that has installed enterpriseDB (833) and upgraded to later
version or 8.4.1 using rpms?
I am wondering what the best path would be to upgrade from enterpriseDB.
Can I do an upgrade from enterpriceDB 8.3.3 to rpms 8.3.8 without dumping and
restoring the database?
When
Jasen Betts writes:
> On 2009-11-17, Ashesh Vashi wrote:
>> You can always use the environment variable PGPASSWORD to do that.
>> Though - it is not recommended to use for security reason. :(
> as long as it's not in the default environment it's better than a
> command-line password.
On some pl
On Thursday 26 November 2009, Sam Jas wrote:
> We are daily processing millions of rows and loadiing into database. We
> have marked that when we create a new database it worked fine upto 20 or
> 25 days. After that we are getting errors like "read only file system" ,
> data is corrupted. Therefo
=?UTF-8?B?SsOpcsO0bWUgRXTDqXbDqQ==?= writes:
> I know this is none of the user's business, but I'm wondering how
> blob's implemented as oid are stored in the postgresql data storage.
> Are each of them kept in a separate file, or are they chunked into
> pieces and scattered ?
They're in chunks i
Hi list,
How could I transparently log an error where user miss a right,
I know how to write a RULE, but not this way:
ie:
* user don't have a direct access to tables but to procedures that
manipulates tables.
* He try to make a: SELECT * FROM table5
which normally returns: "ERROR: right
Thanks Tom.
J.
2009/11/26 Tom Lane :
> =?UTF-8?B?SsOpcsO0bWUgRXTDqXbDqQ==?= writes:
>> I know this is none of the user's business, but I'm wondering how
>> blob's implemented as oid are stored in the postgresql data storage.
>> Are each of them kept in a separate file, or are they chunked into
>
Hi,
After a recent server crash after which the whole system hung and power had
to be pulled, I'm having the following error pop up when trying to start the
DB:
* Starting PostgreSQL 8.4 database server
* The PostgreSQL server failed to start. Please check the log output:
2009-11-26 16:00:23
On Thu, Nov 26, 2009 at 9:06 AM, Shak wrote:
> Hi,
>
> After a recent server crash after which the whole system hung and power had
> to be pulled, I'm having the following error pop up when trying to start the
> DB:
>
> * Starting PostgreSQL 8.4 database server
> * The PostgreSQL server failed to
On Thu, Nov 26, 2009 at 6:40 AM, Sam Jas wrote:
>
> Hi Folks,
>
> I am frequently getting read-only file system error on my server.
>
> We are using postgreSQL, GridSQL database. The size of database is very huge.
> Architecture Details:
> CentOS 5.3 64 bit Areca high point rocket raid 3520 8 port
Thanks Tom. As usual, I learned a lot more from your reply than just the
answer to my question .
Bill
Tom Lane wrote:
Bill Todd writes:
I am missing something basic. How can I use an input parameter as the
destination path in a COPY statement in a function.
plpgsql can only substi
Hi,
while using date_trunc('week', some_date) to get the date of the first day of the week I noticed that it was working as expected: Monday is considered the start of the week.
I assume this depends on some locale setting, but I can't figure out which it is, so I
can make sure this is not "a
On Thursday 26 November 2009 1:59:05 pm Thomas Kellerer wrote:
> Hi,
>
> while using date_trunc('week', some_date) to get the date of the first day
> of the week I noticed that it was working as expected: Monday is considered
> the start of the week.
>
> I assume this depends on some locale setting
2009/11/26 Thomas Kellerer
> Hi,
>
> while using date_trunc('week', some_date) to get the date of the first day
> of the week I noticed that it was working as expected: Monday is considered
> the start of the week.
> I assume this depends on some locale setting, but I can't figure out which
> it
2009/11/26 Thomas Kellerer
> Hi,
>
> while using date_trunc('week', some_date) to get the date of the first day
> of the week I noticed that it was working as expected: Monday is considered
> the start of the week.
> I assume this depends on some locale setting, but I can't figure out which
> it
On 26/11/2009 11:56 PM, Jean-Yves F. Barbier wrote:
> Hi list,
>
> How could I transparently log an error where user miss a right,
> I know how to write a RULE, but not this way:
>
> ie:
> * user don't have a direct access to tables but to procedures that
>manipulates tables.
>
> * He try t
On 27/11/2009 12:50 AM, Scott Marlowe wrote:
> On Thu, Nov 26, 2009 at 9:06 AM, Shak wrote:
>> Hi,
>>
>> After a recent server crash after which the whole system hung and power had
>> to be pulled, I'm having the following error pop up when trying to start the
>> DB:
>>
>> * Starting PostgreSQL 8.
Adrian Klaver, 26.11.2009 23:15:
On Thursday 26 November 2009 1:59:05 pm Thomas Kellerer wrote:
Hi,
while using date_trunc('week', some_date) to get the date of the first day
of the week I noticed that it was working as expected: Monday is considered
the start of the week.
I assume this depend
On Fri, Nov 27, 2009 at 08:13, Thomas Kellerer wrote:
[...]
> I'm just curious which setting defines whether monday or sunday is
> considered the "first day in a week"
Read 9.9.2 on http://www.postgresql.org/docs/8.1/static/functions-datetime.html
and you will see that even if you find such sett
29 matches
Mail list logo
