Στις Friday 28 March 2008 19:38:02 ο/η salman έγραψε:
>
> Achilleas Mantzios wrote:
> > Στις Friday 28 March 2008 14:39:53 ο/η A.Burbello έγραψε:
> >> ls -t1p | grep -v / | grep -v backup | head -1
> >
> > maybe:
> > ls -t1p | grep -v / | grep -v backup | grep -v `ls -t1p | grep -v / | grep
> >
Hi team,
I am using COPY to load data in my tables from CSV file.
File size : 16 gb
time taken to drop index + truncate data + load data + apply index is : 1.5 hrs.
how can i reduce the time ?
OS : SOLARIS 10
Machine : THUMPER (x4500, SUN )
Datatbase : greenplum (based on postgresql)
postgres
You're missing this entry from your .11 box:
ACCEPT tcp -- anywhere anywherestate NEW tcp
dpt:postgres
So iptables goes right to the end and then rejects with "Host Prohibited"
which is reported on your .13 box as "No route to host"
I think the command you want on yo
> even on the higher debug levels I am not seeing thing in the postgres logs
Are you increasing the debug levels of Bacula or of Postgres? You'll need to
look in the PG logs and increase their verbosity.
THINK BEFORE YOU PRINT - Save paper if you don't really need to print this
*
hiya
I know this is somewhat offtopic, but I am stuck.
I am trying to get bacula to run and am testing the backup catalog
script. I am using postgres for my database and am getting this error
30-Mar 19:33 collab-dir: BackupCatalog.2008-03-30_19.33.00 Fatal error:
sql_create.c:485 sql_create.c:4
Tom Lane wrote:
Bernhard D Rohrer <[EMAIL PROTECTED]> writes:
I have set my authentication to
# "local" is for Unix domain socket connections only
local all all md5 #ident sameuser
Are you sure this actually took effect (ie did you "pg_ctl reload")?
30-
Bernhard D Rohrer <[EMAIL PROTECTED]> writes:
> I have set my authentication to
> # "local" is for Unix domain socket connections only
> local all all md5 #ident sameuser
Are you sure this actually took effect (ie did you "pg_ctl reload")?
> 30-Mar 17:47 co
"Mikko Partio" <[EMAIL PROTECTED]> writes:
> Interesting. What is planned substitute for VACUUM FULL? CLUSTER?
What's been discussed is something that works roughly like CLUSTER
but doesn't bother to sort the data any particular way (ie, just do
a seqscan not an indexscan in the data-copying phase
Bernhard D Rohrer wrote:
Hi all
I have set my authentication to
# "local" is for Unix domain socket connections only
local all all md5 #ident sameuser
for security reasons
this leads to this problem when trying to run a script:
30-Mar 17:47 collab-dir:
On Sun, Mar 30, 2008 at 6:40 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> It would be good to fix it I suppose, but what with VACUUM FULL being on
> the edge of deprecation anyway, it's hard to muster enthusiasm for doing
> a (probably) large additional amount of work on it, I think most
> hackers w
Hi all
I have set my authentication to
# "local" is for Unix domain socket connections only
local all all md5 #ident sameuser
for security reasons
this leads to this problem when trying to run a script:
30-Mar 17:47 collab-dir: BeforeJob: run command
"
"Mikko Partio" <[EMAIL PROTECTED]> writes:
> On Sun, Mar 30, 2008 at 12:05 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
>> "Mikko Partio" <[EMAIL PROTECTED]> writes:
>>> 2008-03-29 22:25:15 EET [26841]: [3-1] PANIC: cannot abort transaction
>>> 3778747509, it was already committed
>>
>> Yeah, this is
On Sun, Mar 30, 2008 at 12:05 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Mikko Partio" <[EMAIL PROTECTED]> writes:
> > 2008-03-29 22:25:15 EET [26841]: [3-1] PANIC: cannot abort transaction
> > 3778747509, it was already committed
>
> Yeah, this is a well-known problem with VACUUM FULL ...
>
>
O
13 matches
Mail list logo
