Dear Visha/Ashish,
My batch file is content of below script.
@echo off
"C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f D:\test\test1.sql
-F p -C -d -D postgres
@echo on
I check the scheduler also.. That is also running ... Kindly give me the
solution...
Thanks & Regards
Jaya
Sorin N. Ciolofan написа:
Hello!
I'd like to ask you what line should be added in pg_hba.conf file in order
to grant access to a user with ip
139.100.99.98 to a db named "myDB" with user "scott" with password
"mikepwd"?
After modifying this file is enough to issue
pg_ctl reload
or should I res
On Wed, 25 Jul 2007 12:38:31 +
"Vishal Arora" <[EMAIL PROTECTED]> wrote:
>
>
>
> >From: "Milen A. Radev" <[EMAIL PROTECTED]>
> >To: pgsql-admin@postgresql.org
> >Subject: Re: [ADMIN] Using Explain
> >Date: Wed, 25 Jul 2007 14:26:57 +0300
> >
> >Vishal Arora напиÑа:
> > >
> > > Hi All,
Hello!
I'd like to ask you what line should be added in pg_hba.conf file in order
to grant access to a user with ip
139.100.99.98 to a db named "myDB" with user "scott" with password
"mikepwd"?
After modifying this file is enough to issue
pg_ctl reload
or should I restart postgres?
Thank you
Wi
I have a table with informations that change every month, and I have to
update the monthly data in a new column. To do that, I try to find out wich
months are being trated and I perform an update in my table for every month.
So what I'm trying to do is to change the month column for a fixed name,
"Martial Elise KIBA" <[EMAIL PROTECTED]> writes:
> I have a postgresql sever running on RedHat EL 4.0 Update 2.
> ...
> But postgresql steal respond in english, and TO_CHAR(date, 'Day, DD Month
> ') return a date in english
What PG version is this? Are you sure it was built with --enable-nls?
--- Jessica Richard <[EMAIL PROTECTED]> wrote:
> Just want to be very clear that:
>
> 1. adding a primary key will have an implicit index automatically on the
> column(s).
>
> 2. Adding a foreign key will NOT have an index created automatically, it only
> does the
> referencing work. If an in
Just want to be very clear that:
1. adding a primary key will have an implicit index automatically on the
column(s).
2. Adding a foreign key will NOT have an index created automatically, it only
does the referencing work. If an index is needed on the F-key column, it has to
be created, right?
Index will not be used if your string has "wild card" (%) in the
beginning.
It should be used, if you change your query to:
select *
from tb_gen_person
where pes_name like 'albert%';
Igor
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alexander B.
Sent
The statement is perfectly legal.
Danny Abraham
CTM&D BU
972-52-4286-513
[EMAIL PROTECTED]
Hi all!
I have a postgresql sever running on RedHat EL 4.0 Update 2.
the following locales applies to my database:
lc_messages = 'fr_FR.UTF-8' # locale for system error
message
# strings
lc_monetary = 'fr_FR.UTF-8'
Can you send your batch file pls. What is the time you are setting. Hope u r
not doing the same thing as earlier.
-- Vishal
From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>,
Subject: [ADMIN] Backup Scheduler...
Date: Wed, 25 Jul 2007 18:12:
Hi,
When I search some words into a varchar column and this column has an index.
Does Postgres use index??
The search is done this way:
create table tb_gen_person (
pes_nro_doc numeric(14) not null,
pes_name varchar(150) not null,
constraint pk_person PRIMARY KEY(pes_nro_doc)
);
create inde
Dear Ashish/Vishal,
How are u .. Here i am fine... I need a help from u ...
In Windows, I have created new postgresql server & installed pgAgent scheduler
also..The pgAgent service is running, But when I try to schedule the backup
job, it is not running. The script seems to be ok since I ex
From: "Milen A. Radev" <[EMAIL PROTECTED]>
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Using Explain
Date: Wed, 25 Jul 2007 14:26:57 +0300
Vishal Arora напиÑа:
>
> Hi All,
>
> I was looking for extensive tutorial for Explain, Plan-reading. The
> postgres manual is not exhaustive
Vishal Arora написа:
>
> Hi All,
>
> I was looking for extensive tutorial for Explain, Plan-reading. The
> postgres manual is not exhaustive enough.
>
> It would be great if somone has a link to some documentation which gives
> some more in depth information about EXPLAIN / Plan Reading
>
http
Hi All,
I was looking for extensive tutorial for Explain, Plan-reading. The postgres
manual is not exhaustive enough.
It would be great if somone has a link to some documentation which gives
some more in depth information about EXPLAIN / Plan Reading
Thanks
Vishal
___
17 matches
Mail list logo
