- Original Message -
From: "Jean-Luc Lachance"
> Interesting... What happens when you drop and recreate the index???
>
repeat the whole procedure again
hth,
Marin
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do no
Thanks. That seems a better way to go.
At 03:47 PM 4/3/02 -0800, Stephan Szabo wrote:
>On Wed, 3 Apr 2002, Chris Pesko wrote:
>
> > Never mind. Just figured it out. Need to grab the substring from 2 for 8
> > from the to_char result because it holds character number 1 reserv ed for +
> > or -
On Wed, 3 Apr 2002, Chris Pesko wrote:
> Never mind. Just figured it out. Need to grab the substring from 2 for 8
> from the to_char result because it holds character number 1 reserv ed for +
> or - signs. + is default or white space. I think that is the reason. Any
> other input?
You
Never mind. Just figured it out. Need to grab the substring from 2 for 8
from the to_char result because it holds character number 1 reserv ed for +
or - signs. + is default or white space. I think that is the reason. Any
other input?
hwds=# select to_date(substring(to_char(20020101,
I am converting an 8 digit number to a date. I don't see a postgres
function to do it direct, but two functions seems like I'm on the right
track, to_char and to_date. Individually I get them to work, but when I
combine them I get the wrong answer. see below. Can anyone help in
getting the
login using trust authentication method. Then change the password
for postgresql user with
'alter user command. I think this will work .
Thanks
chava
--
Srinivasa R Chava (Chava) <[EMAIL PROTECTED]>
- Boss: Sean T Laduderdale <[EMAIL PROTECTED]>
vnet4603575
Application Developer
Corporate Intr
"William Meloney" <[EMAIL PROTECTED]> writes:
> Developer dropped ~30+ tables from 4 different DBs on the same
> server. Queiries began to fail: unable to locate file;
> /var/lib/pgsql/pg_clog/0006.
>>
>> Hmm. What files do you actually have in /var/lib/pgsql/pg_clog?
> [ info snipped ]
Okay
Title: How to create a user with password
Hi, all:
In the file of pg_hba.conf, I give the following parameter:
TYPE DATABASE IP_ADDRESS MASK
AUTH_TYPE AUTH_ARGUMENT
Local all
On 2 Apr 2002 at 2:09, Tom Lane wrote:
> "William Meloney" <[EMAIL PROTECTED]> writes:
> > PG 7.2 and RH 7.2
> > Developer dropped ~30+ tables from 4 different DBs on the same
> > server. Queiries began to fail: unable to locate file;
> > /var/lib/pgsql/pg_clog/0006.
>
> Hmm. What files do y
"Gaetano Mendola" <[EMAIL PROTECTED]> writes:
> How can I easily backup the table pg_shadow
> or at least how can I backup the data about the users of
> the DB?
See pg_dumpall.
regards, tom lane
---(end of broadcast)---
TI
Interesting... What happens when you drop and recreate the index???
Marin Dimitrov wrote:
>
> - Original Message -
> From: "Judy Jecelin"
>
> >
> > Hi,
> >
> > A relatively novice user of PostgreSQL but not
> > of other databases... I'm trying to understand the
> > use of initlocation.
Bonjour William Meloney
>
>
> My request for comment is comprised of three parts...
>
> 1.) What hardware should I consider when looking at Linux? I know this is a broad
> question but the answer is simple. What hardware are you using to run you Linux
> implementation?
Dual Process
My previous post was a knee jerk reaction to a crash of Postmaster. I did not list it
but Postmaster was named in the crash dump. The top of the message is repeated
here...
Unable to handle kernel NULL pointer dereference at virtual address
0073
*pde =
Oo
William Meloney wrote:
> The beginning of the BSOD (Yes Virginia, Linux gets Black Screens Of Death!!!)...
>
> Unable to handle kernel NULL pointer dereference at virtual address
> 0073
> *pde =
> Oops = 0002
> cpu = 0
> eip = 0010:[]
> eflags = 0
Trevor Astrope wrote:
> I didn't see any errors when restoring the database, so I'm confused why
> the restored database takes up so much less space... Is there any reason
> why this would happen? Is there any easy way to see where I may have lost
> data?
You could also (if you have the disk spa
How can I easily backup the table pg_shadow
or at least how can I backup the data about the users of
the DB?
Ciao
Gaetano
--
#exclude
#include
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t\b\b\b\b\b\b");
---(end of broadcast)---
TIP 4: Don't 'ki
Trevor Astrope <[EMAIL PROTECTED]> writes:
> I restored a 7.1.3 database to another machine which seems to have went
> fine. However, the data on the disk is less than the original machine...
> There is only 6.5GB in pgsql/dta/base on my test machine and the same
> directory on the production mach
On Wed, 3 Apr 2002, Trevor Astrope wrote:
> I restored a 7.1.3 database to another machine which seems to have went
> fine. However, the data on the disk is less than the original machine...
> There is only 6.5GB in pgsql/dta/base on my test machine and the same
> directory on the production mach
"Nicholay P. Chuprynin" <[EMAIL PROTECTED]> writes:
> I switched enable_seqscan to 'false', restarted server and EXPLAINed the
> same query again:
> ...
> Now it uses index scan, but query takes MUCH more time than before (about
> an hour, and it's not finished yet).
> It seems very strange for m
I restored a 7.1.3 database to another machine which seems to have went
fine. However, the data on the disk is less than the original machine...
There is only 6.5GB in pgsql/dta/base on my test machine and the same
directory on the production machine was at 8.4GB at the time of the dump.
This was
The beginning of the BSOD (Yes Virginia, Linux gets Black Screens Of Death!!!)...
Unable to handle kernel NULL pointer dereference at virtual address
0073
*pde =
Oops = 0002
cpu = 0
eip = 0010:[]
eflags = 00010206
...
.
Hello, All!
Today I tried the following query on a large table (11543179 rows).
SELECT sum(raw_bytes)
FROM raw_acct
WHERE raw_date > '2001-12-31'
AND ts_client_id = 93
AND ts_server_id IS NOT NULL;
It took about 4 minutes to complete so I EXPLAINed it:
NOTICE: QUERY PLAN:
Aggregate (cost=3
"Andre Schubert" <[EMAIL PROTECTED]> wrote:
> You can use multilog on linux.
Hi, I don't know what's multilog but I resolved my
problem in this way (general suggestions for all):
#File postgresql.conf
syslog = 2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
#File /etc/logrotate.d/post
23 matches
Mail list logo
