Re: [ADMIN] cyrillic

1999-07-09 Thread sk . list
Hi! On 08-Jul-99 Oleg Broytmann wrote: > Hi! > > On Thu, 8 Jul 1999 [EMAIL PROTECTED] wrote: >> Can user choose its locale while fetching data from postgresql (6.5)? > >Sure! Not only locale, but KOI8<=>CP12521 converting on th fly!!! > >> What I mean: >> >> I have PGSQL in multiuser envi

Re: [ADMIN] cyrillic

1999-07-09 Thread Oleg Broytmann
Hi! I said "Multibyte support", not "Cyrillic RECODE". RECODE is now obsolete. On Fri, 9 Jul 1999 [EMAIL PROTECTED] wrote: > >Look into doc directory. Read details about compiling and using Postgres > > with Multibyte support. There are even special instructions for cyrillic > > users. >

Re: [ADMIN] cyrillic

1999-07-09 Thread Oleg Broytmann
On Fri, 9 Jul 1999 [EMAIL PROTECTED] wrote: > PS. I use 6.4.2 locally that have no cyrillic mb features ;-) and 6.5 on the > host ;-) http://sun.med.ru/~phd/Software/PostgreSQL/ Download 2 (two) *-mb-patch files and apply to 6.4.2. I have no 6.5 anywhere around me - all my servers are 6.4.2

[ADMIN] cannot open segment 1 of relation TABLENAME

1999-07-09 Thread SZALAI Karoly
Hi, I have a very big dbase. czw@newage:~/prog$ psql mamhist -t -q -c "select count(*) from entry;" 10679609 The table size is -rw--- 1 postgres postgres 2133843968 Jul 7 11:15 entry My problem: czw@newage:~/prog$ psql mamhist -t -q -c "select * from entry where radi='500688' and dateac

Re: [ADMIN] cyrillic

1999-07-09 Thread Oleg Bartunov
Hi, here is a brief instruction: 1. get 6.5 distribution. I suppose you can get it from my mirror: ftp.sai.msu.su/pub/unix/database/pgsql/postgresql-6.5.tar.gz 2. untar, cd to src/ and run ./configure --prefix=/usr/local/pgsql --enable-locale --with-mb=KOI8 3. make, make install, make in

[ADMIN] re. scheduled backups and vacuums

1999-07-09 Thread JT Kirkpatrick
>1.)Use mirroring onto this HD for the PGDATA directory tree (which can >abd should be on its own filesystem, IMO). Then, to back up the system, >you break the mirror (which will wait on write activity to stop), back >up the offline disk, then reestablish the mirror. uh oh, the water just c

RE: [ADMIN] wrap a port for v6.5

1999-07-09 Thread Jackson, DeJuan
> > On Thu, 8 Jul 1999, Oleg Broytmann wrote: > > >Run Postgres with TCP/IP disabled (remove -i from start-up > options). > > > > Ok, but I must to integrated postgres with PHP3. If I remove -i php3 > does > > not works. > > Yep, block that port. I don't think php can use unix domain socket

Re: [ADMIN] regular maintenance, backup

1999-07-09 Thread Lamar Owen
[EMAIL PROTECTED] wrote: > > Though it'd be weird to run pg_dumpall from a perl script. > Probably better to keep that separate. Thanks for the perl script -- gives me something to test the rpm perl client installation... ;-) Lamar Owen WGCR Internet Radio

[ADMIN] Re: re. scheduled backups and vacuums

1999-07-09 Thread Lamar Owen
JT Kirkpatrick wrote: > > >1.)Use mirroring onto this HD for the PGDATA directory tree (which can > >abd should be on its own filesystem, IMO). Then, to back up the system, > >you break the mirror (which will wait on write activity to stop), back > >up the offline disk, then reestablish the

[ADMIN] Re: [HACKERS] Problems with src/pl/tcl/mkMakefile.tcldefs.sh.in in 6.5

1999-07-09 Thread Bruce Momjian
I didn't understand this the first time you sent it either. Send me a patch to review, please. > For Digital UNIX 4.0D, shared libraries are created by: > $ ld -shared -expect_unresolved "*" -o foo.so [objects] > > This presents a problem for mkMakefile.tcldefs.sh.in. In tclConfig.sh: >