Thank you Very Much Steve.
On Thu, Jun 3, 2010 at 6:10 AM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> On 06/02/2010 03:29 PM, raghavendra t wrote:
>
>> ...
>>
>> Suppose am at the server-end, how could i get the client-time. Its really
>>
On 06/02/2010 02:48 AM, raghavendra t wrote:
>
>> Hi All,
>>
>> How do i get the client time and server time. I am connecting remotely. If
>> i give SELECT CURRENT_TIME;,it shows the server time. How do we get the
>> client time ?
>>
>> Time is the same e
Hi All,
How do i get the client time and server time. I am connecting remotely. If i
give SELECT CURRENT_TIME;,it shows the server time. How do we get the client
time ?
Thanks in Advance
Regards
Raghavendra
Any suggestions ?
On Thu, Apr 29, 2010 at 4:42 PM, raghavendra t wrote:
> Hi All,
>
> I am using Postgres 8.4. pg_restore -j option. I have dump of the database
> with -Fc and elected the pg_restore -j option for the faster restoration.
> When the restoration process is in prog
Hi All,
I am using Postgres 8.4. pg_restore -j option. I have dump of the database
with -Fc and elected the pg_restore -j option for the faster restoration.
When the restoration process is in progress, i want to monitor the threads
invoked by pg_restore (suppose if i give -j 4). I have verified in
Hi All,
Thank you Magnus, Bruce...!!
Regards
Raghavendra
On Tue, Apr 20, 2010 at 7:20 PM, Bruce Momjian wrote:
> Magnus Hagander wrote:
> > .
> >
> > On Fri, Apr 16, 2010 at 11:55 AM, raghavendra t
> > wrote:
> > > Hi All,
> > >
> > > F
Hi All,
For some setups reason, i started taking Hot backup. In this course I have
first issued pg_start_backup('backup') and went to the data directory for
backing up in OS format using the command "tar -cf backup.tar /data" . When
i issued this command , tar was generating some errors as show b
Hi
> >
> > > You might consider partitioning this table by date, either by day or by
> > > week, and instead of deleting old rows, drop entire old partitions
> >
> > this is not really good workaround...
As a First choice, This is a very good workaround for your present
situation.
As a second
Hi
Hope this will help you out. Its has bothe pg_dump and pg_restore, with -t
option
http://www.postgresql.org/docs/8.4/static/app-pgrestore.html
Regards
Raghavendra
On Wed, Apr 14, 2010 at 8:33 PM, Scott Mead wrote:
>
> On Wed, Apr 14, 2010 at 10:56 AM, akp geek wrote:
>
>> Dear all -
>>
>>
Hi Shoaib,
Thank you very much, now its working after creating the file with 256k.
I also thank everyone who has supported me in this thread.
Regards
Raghavendra
On Wed, Apr 14, 2010 at 3:44 PM, Shoaib Mir wrote:
> On Wed, Apr 14, 2010 at 6:30 PM, raghavendra t
> wrote:
>
>
this.
regards
raghavendra
On Wed, Apr 14, 2010 at 12:39 PM, Shoaib Mir wrote:
> On Wed, Apr 14, 2010 at 5:00 PM, raghavendra t
> wrote:
>
>> Hi Shoaib,
>>
>> Tried with pg_resetxlog
>>
>>
>> [postg...@dbarhel564 bin]$ pg_resetxlog /usr/local/pgsql/m
0" at offset 0: Success.
LOG: startup process (PID 1335) exited with exit code 1
LOG: aborting startup due to startup process failure
[postg...@dbarhel564 bin]$
Regards
Raghavendra
On Wed, Apr 14, 2010 at 12:14 PM, Shoaib Mir wrote:
> On Wed, Apr 14, 2010 at 3:35 PM, raghavendra t
>
transaction 889
DETAIL: Could not read from file "pg_clog/" at offset 0: Success.
LOG: startup process (PID 303) exited with exit code 1
LOG: aborting startup due to startup process failure
~
Regards
Raghavendra
On Wed, Apr 14, 2010 at 11:02 AM, raghavendra t
wrote:
> Hi Ashesh
>
&
r 14, 2010 at 11:00 AM, Ashesh Vashi <
ashesh.va...@enterprisedb.com> wrote:
> What is the value set for the port in postgresql.conf?
>
> --
> Thanks & Regards,
>
> Ashesh Vashi
> EnterpriseDB INDIA: Enterprise Postgres Company<http://www.enterprisedb.com/>
>
Hi All,
Please find the below scenario, and suggest me...
Trying to start the server, but not starting.
--
[postg...@dbarhel564 mypg]$ pg_ctl -D /usr/local/pgsql/mypg/ start
server starting
[postg...@dbarhel564 mypg]$ psql -p 5432 -d postgre
anks & Regards
Raghavendra
2010/4/13
> > raghavendra t wrote:
> >> Hi All,
> >>
> >> Could please guide me in knowing the Dynamic Catalog views which will
> >> tell about the Buffers and Cache information using System Catalogs.
> >>
>
Hi All,
Could please guide me in knowing the Dynamic Catalog views which will tell
about the Buffers and Cache information using System Catalogs.
Thanks in Advance
Regards
Raghavendra
an't
> find the table???
>
> In the future please don't cross post to multiple lists.
>
> Message from raghavendra t
> at 04-03-2010 10:08:11
> PM --
>
>
> step 6 - Issue the commit in Session A
>
> postgres=# commit;
>
> Step -7 now
.
Regards
Raghavendra
On Sat, Apr 3, 2010 at 10:35 PM, Tom Lane wrote:
> raghavendra t writes:
> > I am facing the error "cache lookup failed for relation X" in
> Postgres-8.4.2
> > [ when dropping the same table concurrently in two sessions ]
> > Could plese tell
Hi All,
I am facing the error "cache lookup failed for relation X" in Postgres-8.4.2
version. As you all know, its a reproducable and below is the example.
This can be generated with two sessions;
Am opening two sessions here Session A and Session B
Session A
=
step 1 - creating the table
Hi All,
Which parameter will come into existence for the performance issue on the
REINDEX. As maintenance_work_mem for CREATE INDEX, does the same will be for
the REINDEX.
Thanks in advance.
Regards
Raghavendra
get in the way of many legitimate uses.
Can we create any prompts on the pg_catalogs while doing any operation like
altering/deleting manually.
Regards
Raghavendra
On Mon, Mar 29, 2010 at 8:22 PM, Tom Lane wrote:
> raghavendra t writes:
> > How to give security to the pg_catalogs, as
Hi All,
How to give security to the pg_catalogs, as these are freely alterable and
cause some security problem. Here i mean to say, as a superuser we can
delete the rows from a catalogs are alter the catalogs, is there anyway to
put restriction or any promting before doing anything to catalogs.
An
23 matches
Mail list logo
