Adam Rich wrote:
This seems like a simple question that would have come up, but I'm not
able to find an answer in google, PG docs, or PG mailing list archives.
How do I prevent a user from being able to list all databases in my
cluster? I want to restrict them to seeing just the databases t
Did you find what the reason of crash was?
Log seems that the data is corrupted as the system was
crashed. Smart way it to reload data from the valid backup and start your work.
If you don’t have a valid backup then at last touch the file (68157) and try to
restart your db.
--
Thanks
Sam
Below are the options that you can use to create user and assign them
privileges according to your environment.
Command: CREATE USER
Description: define a new database role
Syntax:
CREATE USER name [ [ WITH ] option [ ... ] ]
where option can be:
SUPERUSER | NOSUPERUSER
| CREATED
This seems like a simple question that would have come up, but I'm not
able to find an answer in google, PG docs, or PG mailing list archives.
How do I prevent a user from being able to list all databases in my
cluster? I want to restrict them to seeing just the databases they have
connect
Hey Folks,
I want to run a warm standby scenario by you. I'm pretty sure it'll
work, but it's a very large database so even the slightest mistake can
mean a major setback.
Scenario:
Server A is the provider node, shipping WAL files to Server B. Server
B is destined to become the provider
2009/10/21 Patrick Brückner :
> Hi,
>
> after a computer crash my postgres 8.2.14 installation under Windows XP SP3
> doesn't start anymore. Here is the log file:
>
> 2009-10-21 23:57:10 FATAL: could not count blocks of relation
> 1663/68065/68157: Permission denied
> I assume it has something to
On Wed, Oct 21, 2009 at 07:17:44PM -0700, semi-ambivalent wrote:
> If I have a table with fields A, B, C and D how could I do something
> such that if I insert values in fields A, B and C field D would be
> auto-filled with the value A||B||C? Just a pointer of where to begin
> looking is fine. Trig
If I have a table with fields A, B, C and D how could I do something
such that if I insert values in fields A, B and C field D would be
auto-filled with the value A||B||C? Just a pointer of where to begin
looking is fine. Triggers? Copy ... From? Table or field definitions?
thx
--
Sent via pgsql
Hi,
after a computer crash my postgres 8.2.14 installation under Windows XP
SP3 doesn't start anymore. Here is the log file:
C:\Dokumente und Einstellungen\Admin>2009-10-21 23:57:09 LOG: database
system was interrupted while in recovery at 2009-10-21 22:21:14
2009-10-21 23:57:09 HINT: This pr
Sim Zacks wrote:
I'm using 8.2.4
Numeric with scale precision always shows the trailing zeros.
Numeric plain only shows numbers after the decimal point that are being
used.
I would like to have the data in my table with scale and precision, but
my views to be cast to numeric without any scal
On Wed, Oct 21, 2009 at 4:25 PM, Greg Smith wrote:
> On Wed, 21 Oct 2009, Scott Marlowe wrote:
>
>> In this:
>>
>> Mem: 16432240k total, 16344596k used, 87644k free, 27548k buffers
>> Swap: 10241428k total, 3680860k used, 6560568k free, 6230376k cached
>>
>> The 6.2G cached is considered
On Wed, 21 Oct 2009, Scott Marlowe wrote:
In this:
Mem: 16432240k total, 16344596k used,87644k free,27548k buffers
Swap: 10241428k total, 3680860k used, 6560568k free, 6230376k cached
The 6.2G cached is considered part of the 16G used
So it's not using more memory than it has. It
Scott Marlowe writes:
> In this:
> Mem: 16432240k total, 16344596k used,87644k free,27548k buffers
> Swap: 10241428k total, 3680860k used, 6560568k free, 6230376k cached
> The 6.2G cached is considered part of the 16G used
> So it's not using more memory than it has. It's just th
On Wed, Oct 21, 2009 at 4:01 PM, Greg Smith wrote:
> On Wed, 21 Oct 2009, Waldomiro wrote:
>
>> top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52,
>> 3.36
>> Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi, 0.2%si,
>> 0.0%st
>> Mem: 16432240k total, 16344596k use
On Wed, 21 Oct 2009, Waldomiro wrote:
top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52, 3.36
Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 16432240k total, 16344596k used, 87644k free, 27548k buffers
Swap: 10241428k total, 368086
As a followup to my previous post, here's what a healthy, well behaved
but running under moderate load db server looks like:
top - 15:47:51 up 436 days, 2:31, 3 users, load average: 12.03, 11.86, 12.26
Tasks: 394 total, 7 running, 387 sleeping, 0 stopped, 0 zombie
Cpu(s): 17.3%us, 1.3%sy
On Wed, Oct 21, 2009 at 12:43 PM, Waldomiro wrote:
> Hi,
>
> I have one of my database server that I run the "top" command:
>
> top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52, 3.36
> Tasks: 624 total, 1 running, 623 sleeping, 0 stopped, 0 zombie
> Cpu(s): 1.4%us, 1.1
I've put the English schedule (Désolé utilisateurs Français) on a
calendar for my own use, but made it public in case anyone else might
find it helpful, like syncing it with a mobile device etc:
XML:
http://www.google.com/calendar/feeds/dp7jfelvcbtmks1m021c6rt...@group.calendar.google.com/public/
Radcon Entec wrote:
> Greetings!
>
> PostgreSQL just crashed on a client's machine. There are several
> strange things in the log file for today. Among the strangest is the
> following:
>
> 2009-10-21 12:28:01 EDT anneal 94S-CAPS1.akst.com ERROR: syntax error
> at or near "qecr" at character 2
Greetings!
PostgreSQL just crashed on a client's machine. There are several strange
things in the log file for today. Among the strangest is the following:
2009-10-21 12:28:01 EDT anneal 94S-CAPS1.akst.com ERROR: syntax error at or
near "qecr" at character 2
2009-10-21 12:28:01 EDT anneal 94
Waldomiro wrote:
Hi,
I have one of my database server that I run the "top" command:
top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52,
3.36
Tasks: 624 total, 1 running, 623 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi,
On Wed, 2009-10-21 at 14:40 +0900, Tatsuo Ishii wrote:
> While attending a Linux conference, a guy said that 10,923 lines of
> code are added and 5,547 lines of code are deleted per day in average
> in Linux development. This is an interesting number and I just wonder
> anybody ever tries to calcul
On Wed, 21 Oct 2009, Waldomiro wrote:
I'm afraid of two things, one is the "load average", I think 3 is too
much, another is the "swap", almost 4GB of swap, I think that is too much
swap.
Am I right?
Not necessarily.
Can I use those indicators to know if my database is ok?
Perhaps.
Hi,
I have one of my database server that I run the "top" command:
top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52, 3.36
Tasks: 624 total, 1 running, 623 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi, 0.2%si,
0.0%st
Mem
Hi,
I have one of my database server that I run the "top" command:
top - 16:16:30 up 42 days,
13:23, 4 users, load average: 3.13, 3.52, 3.36
Tasks: 624 total, 1 running, 623 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi, 0.2%si,
0.0%st
Me
On Wed, 2009-10-21 at 14:43 +0530, utsav wrote:
> Kindly clarify that whether PostgreSQL 8.4.1 is supported on RHEL 4
> and RHEL 5.2, and what type of installation binaries are available
> ( RPM etc) for it.
Per http://yum.pgsqlrpms.org/rpmchart.php , both distros are supported.
RPMs are availab
10/21/2009 08:40 AM, Tatsuo Ishii:
Does anyone know such number?
With some script binding the PG SCM you could easily find that.
It's all about SUMming "--" and "++" from commit diffs.
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche & Developpement
Dear PG community,
I would like to know if anyone there is using pgsphere ( v 1.1.0) with PG
v 8.3.6 , I have few questions regarding the compatibility of this 2
versions.
Thank you,
Isabella
--
View this message in context:
http://www.nabble.com/Pg-and-pgsphere-users-tp25996708p25996708.htm
On Wednesday 21 October 2009 01:23:18 am Ivano Luberti wrote:
> The problem is how you use those data ?
> I have used schemas to split data when I had to manage large amount of
> data (hundred of thousand records) that are (almost) never going to be
> used together, if not for statistic purposes an
On Tuesday 20 October 2009 10:05:34 pm Roderick A. Anderson wrote:
> John wrote:
> > Hi,
> >
> > Is it better to create multi databases or create multi schemas?
>
> John, I just gave a talk on multi-tenant Pg clusters at PgConf West
> 2009 that may help you but ran into vehicle problems and just g
Hello to all,
I have been using Talend now for a few months and am very happy with the
software. I have seen on the website
(http://www.talend.com/partners/index.php ) the page on the Talend
certification and the exam.
I'm pretty curious to see what it takes to take the exam, if you need to be
On Wed, Oct 21, 2009 at 12:37 AM, Pavel Stehule wrote:
> 2009/10/21 Merlin Moncure :
>> On Tue, Oct 20, 2009 at 5:12 PM, Pavel Stehule
>> wrote:
[ shrug... ] There are other possible reasons why the planner would
fail to flatten a subquery, but none of them apply to the example you
>>
Tatsuo Ishii wrote:
> Hi,
>
> While attending a Linux conference, a guy said that 10,923 lines of
> code are added and 5,547 lines of code are deleted per day in average
> in Linux development. This is an interesting number and I just wonder
> anybody ever tries to calculate these numbers with P
Dear All,
Kindly clarify that whether PostgreSQL 8.4.1 is supported on RHEL 4 and RHEL
5.2, and what type of installation binaries are available ( RPM etc) for it.
Also can I upgrade the Postgresql 7.4.6-1 to PostgreSQL 8.4.1.
Regards,
Utsav Turray
Disclaimer :- This e-mail and any attachment m
Pavel Stehule writes:
>> I know that postgresql array implementation is not right complete and that
>> if just
>> one element of array is NULL the basics array function (array_dims,
>> array_upper, etc.) returns NULL.
> It's not true. Dimensions are stored independent to content.
I wonder if t
Gaini Rajeshwar writes:
> I am doing a fulltext search something like this:
> SELECT doc_id FROM docs WHERE tsv_title($$'magnetic induction'$$) OR
> tsv_body($$'magnetic induction'$$) OR tsv_abstract($$'abstract'$$)
Since you haven't told us what those functions do, we're just guessing.
But I wo
Sergey Konoplev writes:
> Is there a way (or workaround) to make it use i_test_table__created
> for frequent and i_test_table__tsvector_1 for sparse words?
You would need to update to 8.4 for that --- 8.3 does not have any
support for statistics estimation for @@.
(Whether 8.4 would get it right
Also OR operator taking time.
--- On Wed, 21/10/09, Gaini Rajeshwar wrote:
From: Gaini Rajeshwar
Subject: [GENERAL] How to use Logical Operators in Fulltext Search?
To: "pgsql-general@postgresql.org mailing list"
Date: Wednesday, 21 October, 2009, 1:12 PM
Hi All,
I am doing a fulltext searc
Can we have a explain plan SELECT doc_id FROM docs WHERE tsv_title($$'magnetic
induction'$$) OR
tsv_body($$'magnetic induction'$$) OR tsv_abstract($$'abstract'$$)
--
Thanks
Sam
--- On Wed, 21/10/09, Gaini Rajeshwar wrote:
From: Gaini Rajeshwar
Subject: [GENERAL] How to use Logical Operato
Hi All,
I am doing a fulltext search something like this:
SELECT doc_id FROM docs WHERE tsv_title($$'magnetic induction'$$) OR
tsv_body($$'magnetic induction'$$) OR tsv_abstract($$'abstract'$$)
It is taking approximately 100 secs to execute.
But running the query on individual column something
Hi, All
Well what do we have?
8 core, 32 GB, RAID 10, CentOS 5.2, Pg 8.3
A query using tsearch in WHERE block with ORDER and LIMIT:
select * from test_table where obj_tsvector @@
make_tsquery('some_words', 'utf8_russian') and obj_status_did = 1
order by obj_created desc limit 10;
Two indexes -
>
> I know that postgresql array implementation is not right complete and that if
> just
> one element of array is NULL the basics array function (array_dims,
> array_upper, etc.) returns NULL.
> I need to send a list of parameters (which could contain NULL values) and
> evaluate the parameters
2009/10/21 Csaba Nagy :
> Hi Thom,
>
> Sorry for the delay, I got sick in the meantime. I see that others
> already did some review, I will do a quick one too, later maybe I'll
> actually try it out... so after a quick review:
>
> * on line 218, the " ENCODING '$DBname')" part feels wrong, you prob
-Original Message-
From: Greg Smith [mailto:gsm...@gregsmith.com]
On Wed, 21 Oct 2009, Scott Marlowe wrote:
>> Actually, later models of linux have a direct RAID-10 level built in.
>> I haven't used it. Not sure how it would look in /proc/mdstat either.
>I think I actively block memor
Hi Thom,
Sorry for the delay, I got sick in the meantime. I see that others
already did some review, I will do a quick one too, later maybe I'll
actually try it out... so after a quick review:
* on line 218, the " ENCODING '$DBname')" part feels wrong, you probably
want hardcoded UTF8 encoding th
I need to create a pl/pgsql function witch accept a list of parameters and
evaluate them.
I've tried this
CREATE OR REPLACE FUNCTION get_first_valid (lista_elementi VARCHAR[])
RETURNS VARCHAR AS $$
DECLARE
the_oneVARCHAR;
BEGIN
IF (ARRAY_UPPER(lista_elementi, 1) IS NOT
The problem is how you use those data ?
I have used schemas to split data when I had to manage large amount of
data (hundred of thousand records) that are (almost) never going to be
used together, if not for statistic purposes and offline processing.
If you never need to select those data all toge
I tried Power Architect for about 5 minutes, just enough time to
notice it had no support for UUIDs which makes it all but useless.. I
mean, seriously who doesn't use UUIDs :)
Maybe they'll fix that, it does look promising..
>>
>> Search the archives this came up within the last couple of months
InterRob a écrit :
>> Arnaud Lesauvage a écrit :
>> Also, doing a search like :
>> SELECT * FROM mytable WHERE upper(myflied) ILIKE u&'%c29f%';
>> Gives me 0 result.
>> Am I wrong to think that the error 'character 0xc29f of UTF8' relates
>> to the character with code point C29F in UTF8 ?
>
I wou
On Wed, 21 Oct 2009, Scott Marlowe wrote:
Actually, later models of linux have a direct RAID-10 level built in.
I haven't used it. Not sure how it would look in /proc/mdstat either.
I think I actively block memory of that because the UI on it is so cryptic
and it's been historically much mor
50 matches
Mail list logo
