l it checks all table data... or not... :)
>
>
>
> -Original Message-
> From: Nilesh Govindarajan
> To: Iñigo Martinez Lasala
> Cc: Amit jain , pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] How to add constraints without validating data.
> Date: Thu, 27 May 2
assy
> Techzone,
> Rajiv Gandhi Infotech Park, Hinjewadi Phase II, Pune 411 057.
> Phone : +91.20.40262000 Ext 2163 | Mobile:+91.9561298565 | VoIP :
> +1.732.415.0894
> http://www.synechron.com MailTo: amitj...@synechron.com
>
>
>
>
>
How would disabling triggers h
that. If you add a constraint
using ALTER TABLE it will check existing data also. One option is you
create a new table with the constraints and same column names then:
insert into newtable values ( select * from oldtable)
but again this will check for old data, but may be faster.
--
Nilesh Govin
On 04/05/10 08:54, Scott Marlowe wrote:
On Sun, Apr 4, 2010 at 8:21 PM, Nilesh Govindarajan wrote:
Hi,
I wish to execute VACUUM FULL when DB touches a specific size. How to do it
?
I'm aware about the caveats of VACUUM FULL.
Write a bash script that cds to the data dir and runs
Hi,
I wish to execute VACUUM FULL when DB touches a specific size. How to do
it ?
I'm aware about the caveats of VACUUM FULL.
--
Nilesh Govindarajan
Site & Server Administrator
www.itech7.com
मेरा भारत महान !
मम भारत: महत्तम भवतु !
--
Sent via pgsql-admin mailing list (pg
On 03/29/2010 12:50 PM, Guillaume Lelarge wrote:
Le 29/03/2010 04:04, Nilesh Govindarajan a écrit :
Hi, it seems to be working now. Can somebody explain to me how ? See
this pg_hba.conf -
# "local" is for Unix domain socket connections only
local all root trust
local all all md5
#
7.0.0.1/32 md5
host all all ::1/128 md5
Its the same code I think which I wrote previously. But now it asks
password when connected through TCP and doesn't when connected directly
as psql -d postgres
PLZ EXPLAIN !! I'm in a big confusion :?
--
Nilesh Govindarajan
Site & Server
On 03/29/2010 02:51 AM, Guillaume Lelarge wrote:
Le 28/03/2010 19:11, Nilesh Govindarajan a écrit :
[...]
I'm trying to setup PostgreSQL so that, it will not ask password when
connected locally (socket) whereas it will ask when connected using
TCP/IP. This should apply ONLY to root account
t all root 127.0.0.1/32 trust
#host all root ::1/128 trust
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
I cannot give passwordless access to TCP/IP because then it will become
a big security hole using PhpPgAdmin exposed to the public.
--
Nilesh Govindarajan
Site & Server Admi
On 02/20/2010 11:14 PM, Kevin Grittner wrote:
Nilesh Govindarajan wrote:
I want a script to backup all databases table by table in different
.sql files.
My first question would be whether they all need to be from the same
point in time? Is it a requirement that if they were all restored
On 02/20/2010 11:23 PM, Scott Marlowe wrote:
On Sat, Feb 20, 2010 at 10:11 AM, Nilesh Govindarajan wrote:
I want a script to backup all databases table by table in different .sql
files.
Why? It may be that pg_dump / pg_restore already provide the
functionality you are looking for.
How to
I want a script to backup all databases table by table in different .sql
files.
How to do this ?
Also since it is a script, there has to be some role having read access
to all tables on all databases. How to grant that ?
--
Nilesh Govindarajan
Site & Server Adminstrator
www.itech7
12 matches
Mail list logo