merry christmas all! having some postgres issues, was trying to backup another one of my netapp's via nfs and getting very slow backup rate"
Elapsed time: 2 days 21 hours 8 mins 54 secs Priority: 10 FD Files Written: 6,206,323 SD Files Written: 6,206,323 FD Bytes Written: 444,458,726,167 (444.4 GB) SD Bytes Written: 445,477,079,297 (445.4 GB) Rate: 1785.4 KB/s finally cancelled the backup. this is nominally the same mount as my other netapp that gets around 25MB/s, mount looks like this: aspen:/vol/vol0 on /aspen type nfs (ro,rsize=32768,wsize=32768,tcp,addr=xxx.xxx.xxx.xxx) birch:/vol/vol0 on /birch_vol0 type nfs (ro,rsize=32768,wsize=32768,tcp,addr=xxx.xxx.xxx.xxx) aspen got 25MB/s, birch got 1.8MB/s. i cannot see any difference in the network interfaces, both are running at 1000Mb/s: # ssh birch ifstat -a -- interface e0a (194 days, 9 hours, 33 minutes, 23 seconds) -- RECEIVE Frames/second: 21 | Bytes/second: 14478 | Errors/minute: 0 Total frames: 5559m | Total bytes: 3196g | Total errors: 0 Multi/broadcast: 114m | No buffers: 0 | Non-primary u/c: 6 Tag drop: 0 | Vlan tag drop: 0 | Vlan untag drop: 0 Runt frames: 0 | Long frames: 0 | CRC errors: 0 Length Error: 0 | Code Error: 0 | Dribble Error: 0 TRANSMIT Frames/second: 955 | Bytes/second: 1413k | Errors/minute: 0 Total frames: 14652m | Total bytes: 19612g | Total errors: 0 Multi/broadcast: 55847 | Queue overflows: 0 | No buffers: 0 CRC errors: 0 | Abort Error: 0 | Runt frames: 0 Long frames: 0 | Single collision: 0 | Late collisions: 0 Deferred: 0 LINK_INFO Current state: up | Up to downs: 2 | Speed: 1000m Duplex: full | Flowcontrol: full # ssh aspen ifstat -a -- interface e0a (194 days, 9 hours, 33 minutes, 40 seconds) -- RECEIVE Frames/second: 26 | Bytes/second: 22388 | Errors/minute: 0 Total frames: 2155m | Total bytes: 1578g | Total errors: 0 Multi/broadcast: 114m | No buffers: 0 | Non-primary u/c: 6 Tag drop: 0 | Vlan tag drop: 0 | Vlan untag drop: 0 Runt frames: 0 | Long frames: 0 | CRC errors: 0 Length Error: 0 | Code Error: 0 | Dribble Error: 0 TRANSMIT Frames/second: 8 | Bytes/second: 1107 | Errors/minute: 0 Total frames: 4949m | Total bytes: 5903g | Total errors: 0 Multi/broadcast: 213k | Queue overflows: 0 | CRC errors: 0 Abort Error: 0 | Runt frames: 0 | Long frames: 0 Single collision: 0 | Late collisions: 0 | Deferred: 0 LINK_INFO Current state: up | Up to downs: 3 | Speed: 1000m Duplex: full | Flowcontrol: full so i figured i'd just restart bacula and postgres and see if that had any affect. when trying to down postgres i get this" $ /usr/local/pgsql/bin/pg_ctl -D /var/lib/pgsql/data -l logfile stop waiting for server to shut down............................................................... failed pg_ctl: server does not shut down and there are a log of errors in the log like this: NOTICE: CREATE TABLE will create implicit sequence "basefiles_baseid_seq" for serial column "basefiles.baseid" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "basefiles_pkey" for table "basefiles" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "unsavedfiles_pkey" for table "unsavedfiles" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cdimages_pkey" for table "cdimages" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "status_pkey" for table "status" ERROR: role "bacula" already exists STATEMENT: create user bacula; ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: index "delinx1" does not exist STATEMENT: DROP INDEX DelInx1 ERROR: index "delinx1" does not exist STATEMENT: DROP INDEX DelInx1 ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: index "delinx1" does not exist STATEMENT: DROP INDEX DelInx1 ERROR: index "delinx1" does not exist STATEMENT: DROP INDEX DelInx1 ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: index "delinx1" does not exist STATEMENT: DROP INDEX DelInx1 ERROR: index "delinx1" does not exist STATEMENT: DROP INDEX DelInx1 ERROR: table "delcandidates" does not exist STATEMENT: DROP TABLE DelCandidates ERROR: index "delinx1" does not exist STATEMENT: DROP INDEX DelInx1 ERROR: index "delinx1" does not exist why won't postgres shutdown? the only db in it is bacula. is it safe to kill it and restart? -- michael ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
