Re: FW: [ADMIN] Setting up of PITR system.

2006-04-13 Thread Grega Bremec
the WALs? scp? rsync? Kind regards, - -- Grega Bremec gregab at p0f dot net -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.0 (GNU/Linux) iD8DBQFEPgU9fu4IwuB3+XoRA+MeAJ0dbbfcgBqP9SCYq0VICN8xrtGN0wCffE6i kq1LlDwlJwmfrOtwRBwGqFg= =olf3 -END PGP SIGNATURE

Re: FW: [ADMIN] Setting up of PITR system.

2006-04-08 Thread Grega Bremec
. A quick scan reveals there is not much left to be improved, though. Kind regards, - -- ~Grega Bremec ~gregab at p0f dot net -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.0 (GNU/Linux) iD8DBQFEN68Vfu4IwuB3+XoRAxbjAJ49Hg6d9J0RZLywEZLr3WeD1sHevQCfSOm8 Pr3jEYb/+viTp/OAoJ6a5/M= =9e0i -END

Re: FW: [ADMIN] Setting up of PITR system.

2006-04-03 Thread Grega Bremec
backup directory and having them stick around for a period of time before removing them isn't a bad idea either, just in case something goes wrong with your latest backup. You could go about that using find as well; see the -ctime predicate in find(1). Kind regards, - -- ~Grega Bremec ~gregab

Re: [ADMIN] Show tables query

2006-04-02 Thread Grega Bremec
schema you're interested in or add other schemas according to your preference. Also, take a look at system view pg_tables (\d pg_tables). Also, take a look at the archives, Elein once posted a nice set of views ~ and statements you can use for such purposes. Hope this helped, - -- ~Grega Bremec

Re: FW: [ADMIN] Setting up of PITR system.

2006-04-02 Thread Grega Bremec
is the safest option though, and it is also the least disruptive one as it doesn't require any changes to the environment. Kind regards, - -- ~Grega Bremec ~gregab at p0f dot net -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.0 (GNU/Linux) iD8DBQFEL9x/fu4IwuB3+XoRA3IgAJ9Qn7dYsNhv3e9f+P64mJoiz

Re: FW: [ADMIN] Setting up of PITR system.

2006-04-01 Thread Grega Bremec
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Grega Bremec wrote: | ~ find ${WAL_ARCHIVE} -type f | sort -g | while read archive; do | ~if [ ! ${archive} = ${REF_FILE} ]; then Actually, this test is only possible since ${REF_FILE} was expanded using the ${WAL_FILE} mask

Re: FW: [ADMIN] Setting up of PITR system.

2006-03-30 Thread Grega Bremec
nevertheless. It also has functionality for storing ACLs and xattrs in the tar header, works on numerous UNIX flavours and comes as a system package with most of the popular distributions. Hope this helped, - -- ~Grega Bremec ~gregab at p0f dot net -BEGIN PGP SIGNATURE- Version

Re: [ADMIN] Postgresql and uPortal

2006-03-03 Thread Grega Bremec
set. | - changes in other system parms Please specify more specific details on your current system environment. You have not really given enough information to give any directly related hints. Regards, - -- ~Grega Bremec ~gregab at p0f dot net -BEGIN PGP SIGNATURE- Version: GnuPG

Re: [ADMIN] No Space Left On Device

2005-06-21 Thread Grega Bremec
. But then again, it may be something completely different. :) Hope this helps. Kind regards, - -- Grega Bremec gregab at p0f dot net -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFCt+hYfu4IwuB3+XoRAveFAJ4mBHPHjFeTq2Nj1A0aHhG38VhBMgCfU+RW OgFvrUlf7TLpnN2lHWFSRQQ= =tbul

Re: [ADMIN] REMOVE

2005-05-09 Thread Grega Bremec
if they do not desire so. Cheers, - -- Grega Bremec gregab at p0f dot net -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFCf2C9fu4IwuB3+XoRAsurAJwJ0XwaxVipgC4ltyRzv6UBxJyjVACfTraI QJH12kmwv9UzBZkNsK8CXWs= =3F06 -END PGP SIGNATURE- ---(end of broadcast

Re: [ADMIN] Pseudo-Off-topic-survey: Opinions about future of Postgresql(MySQL)?

2004-08-15 Thread Grega Bremec
, with _enormously_ greater resources, found it futile to continue maintaining. There are scenarios that make sense, but not that one. Indeed, that is what seems to be the case. Cheers, -- Grega Bremec Senior Administrator Noviforum Ltd., Software Media http://www.noviforum.si

Re: [ADMIN] PostgreSQL With Slackware

2004-06-23 Thread Grega Bremec
directoeis, put the attached data_dirs file into postgres home directory. After you've done that, everything should go smoothly on startup. (Hopefully the patches go through to the list, if not and anybody is interested, e-mail me and I'll send them to you too.) Hope this helped, -- Grega

Re: [ADMIN] PostgreSQL With Slackware

2004-06-23 Thread Grega Bremec
...and on Wed, Jun 23, 2004 at 08:53:01AM +0200, Grega Bremec used the keyboard: Recap - patch /etc/rc.d/rc.sysvinit with the attached patch, create $ mkdir /etc/rc.d/{init,rc{0,1,2,3,4,5,6}}.d Eeek, seems there's been a mismatch in the original source file I used to create the patch

[ADMIN] Refined LC_COLLATE or multiple database clusters?

2004-06-09 Thread Grega Bremec
, -- Grega Bremec Senior Administrator Noviforum Ltd., Software Media http://www.noviforum.si/ pgpitMpqhEJ9o.pgp Description: PGP signature

Re: [ADMIN] [PERFORM] Quad processor options

2004-05-11 Thread Grega Bremec
functionality in the event of a hotswap taking place. Hope this helped, -- Grega Bremec Senior Administrator Noviforum Ltd., Software Media http://www.noviforum.si/ pgp2JqHMlTO7C.pgp Description: PGP signature

Re: [ADMIN] Raw devices vs. Filesystems

2004-04-07 Thread Grega Bremec
in one go, hell, I'm willing to try it out myself in an attempt to extract off of it, some performance indicators that could be compared to other database performance tests sent to both this and the PERFORM mailing list. So, anyone? :) Cheers, -- Grega Bremec Senior Administrator

Re: [PERFORM] [ADMIN] Raw devices vs. Filesystems

2004-04-07 Thread Grega Bremec
for the record, what POSIX semantics can a postmaster live without in a filesystem? Cheers, -- Grega Bremec Senior Administrator Noviforum Ltd., Software Media http://www.noviforum.si/ pgp0.pgp Description: PGP signature

Re: [ADMIN] Database Encryption (now required by law in Italy)

2004-03-05 Thread Grega Bremec
in the case of a security breach. Cheers, -- Grega Bremec Senior Administrator Noviforum Ltd., Software Media http://www.noviforum.si/ pgp0.pgp Description: PGP signature

Re: [ADMIN] ERD tool for postgres?

2004-01-04 Thread Grega Bremec
on that). The original post is dated 20031110. Hope this helped, -- Grega Bremec System Administration Development Support grega.bremec-at-noviforum.si http://najdi.si/ http://www.noviforum.si/ pgp0.pgp Description: PGP signature

Re: [ADMIN] eRserver (slightly offtopic)

2003-12-01 Thread Grega Bremec
that it really is worth a look. One has to decide one's interested and truely wants to find something useful in a tool though, before one can see its true value. Hope this helped. -- Grega Bremec System Administration Development Support grega.bremec-at-noviforum.si http

Re: [ADMIN] handling different languages in a database

2003-07-29 Thread Grega Bremec
to store and create several databases. Cheers, -- Grega Bremec Sistemska administracija in podpora grega.bremec-at-noviforum.si http://najdi.si/ http://www.noviforum.si/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Latin character set (OFF-TOPIC)

2003-06-28 Thread Grega Bremec
of it automatically by sourcing your ~/.Xresources or ~/.Xdefaults file. See http://www.tldp.org/HOWTO/mini/Intkeyb/index.html for a more in-depth description of setting up international keyboards in the X Window system using Xmodmap and XKB. Hope this helps, -- Grega Bremec System

Re: [ADMIN] IMPORTANT:migration de mysql =postgresql

2003-06-21 Thread Grega Bremec
, with the exception of subselects, which _are_ ENOENT. :) They are scheduled for 4.1, which is (as of time speaking) still marked as alpha. Cheers, -- Grega Bremec Sistemska administracija in podpora grega.bremec-at-noviforum.si http://najdi.si/ http://www.noviforum.si