On Monday 27 August 2007 21:44:29 Tom Lane wrote:
> Kevin Kempter <[EMAIL PROTECTED]> writes:
> > How do I check to see which tables have been vacuumed recently and when
> > they were last vacuumed?
>
> As of 8.2, there are columns about this in the pg_stat views, assuming
> you have the right stat
Kevin Kempter <[EMAIL PROTECTED]> writes:
> How do I check to see which tables have been vacuumed recently and when they
> were last vacuumed?
As of 8.2, there are columns about this in the pg_stat views, assuming
you have the right stats collection options turned on.
reg
Hi List;
How do I check to see which tables have been vacuumed recently and when they
were last vacuumed?
Thanks in advance...
/Kevin
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.
hi, after reading the source of pgloader,i have a idea,use perl to create the
flat file, and, when error,reject the row,seek the next line,continue to copy.
thanks everyone.
[EMAIL PROTECTED] 写道： 日期: Mon, 27 Aug 2007 16:18:35 +0800 (CST)
发件人: <[EMAIL PROTECTED]>
主题: [ADMIN] Copy cmd error
收件人: p
Robert Treat <[EMAIL PROTECTED]> writes:
> LOG: database system was interrupted while in recovery at log time
> 2007-07-30
> 19:17:37 EDT
> I am curious how this date is determined by postgres/pitr?
It's the update timestamp in pg_control, which in essence is going to be
the completion time of
Hi Neil.
On postgresql.conf I changed the listen_address to *.
Then commented the first host entry on pg_hba.conf
then restarted the server.
I wasnt able to log to the client on the command line (psql) because or
missing or erroneos pg_hba.conf. So I added again the first host entry and
restarte
Today I was running some tests on one of our warm standbys. The way this test
works is I took a zfs snapshot of the filesystem, induce failover, of the
pitr host, then log in and play around with the data. Once we're done with
this, I rolled back the zfs snapshot, restart the standby instance, a
On 8/27/07, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> hi,all
>
> I use COPY cmd to import large data to database,but I have a question,
>
> when occured the first error, It always stopped, I need it to be
> continue,and reject the error rows to a file, how to do this?
There are two common way
Check the parameter listen_addresses in the postgresql.conf file to set the
correct value for you (may be '*' to test).
Remove or comment the first host entry. I guess it is not a valid
CIDR-ADDRESS value ;-)
Restart your server and try again your java application.
Neil Peter Braggio
[EMAI
Hello. I need your help.
I have a box running Fedora Core 6. I installed the Postgres Server using
yum, so i have the distributing software.
Ever since i installed it im having problems connecting my java applications
to the database.
But first thing first:
This is the error message i get when
Another view is...by the time you figure out all these virtualization
solutions you can buy a used box for less than $100 (no monitor needed) and
focus on the real test. By the way, in any HA one issue will be the IP
takeover on the surviving node. Under the IP will be the Mac address of the
previ
Hi,
Le lundi 27 août 2007, [EMAIL PROTECTED] a écrit :
> I use COPY cmd to import large data to database,but I have a question,
>
> when occured the first error, It always stopped, I need it to be
> continue,and reject the error rows to a file, how to do this?
You can try out pgloader, which has
hi,all
I use COPY cmd to import large data to database,but I have a question,
when occured the first error, It always stopped, I need it to be continue,and
reject the error rows to a file, how to do this?
thanks!
-
雅虎邮箱，以安全著称，是值得信赖的邮箱专家！
Geoffrey wrote:
> Aug 27 00:59:07 gan-lxc-01 kernel: Out of Memory: Killed process 26169
> (postmaster).
> So, my question is, based on the configuration of this box and the
> configuration of postgresql, can anyone point to anything that might cause
> this to happen?
An operating system conf
I've recently reviewed the various recent threads on out of memory
problems. We just had a similar issue last night. We have 11
postmasters running on two machines in a cluster environment. Five on
one, six on the other. They've been running in this manner for a little
over a year now.
Co
a del film: è in REGALO!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6614&d=20070827
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
l e-mail, gratis per te: http://www.email.it/f
Sponsor:
Hai bisogno di contanti per realizzare i tuoi desideri? Prometeo ti propone
prestiti da 1.500 a 31.000 Euro! Clicca qui per un preventivo immediato.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6916&d=2
On Fri, Aug 24, 2007 at 07:28:43AM -0700, Joshua D. Drake wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Arnau wrote:
> > Hi all,
> >
> > I'd like to do some tests with replication, high availability, ...
> > with PostgreSQL. The problem I have is I don't have enough hardware to
>
hi,all
I use COPY cmd to import large data to database,but I have a question,
when occured the first error, It always stopped, I need it to be continue,and
reject the error rows to a file, how to do this?
thanks!
-
雅虎邮箱，以安全著称，是值得信赖的邮箱专家！
19 matches
Mail list logo
