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

On 9 Jul 1999 [EMAIL PROTECTED] wrote: > Hello > > What is port 6542 ? The port where postgresql run. Qualunque cosa tu stia cercando su Internet, ci sarà almeno un sito porno che risponderà ai tuoi criteri. -- Michel Morelli [EMAIL PROTECTED]

Re: [ADMIN] cyrillic

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 environ

Re: [ADMIN] regular maintenance, backup

On 8 Jul, Lamar Owen wrote: > Try the following one-liner (yes, one liner. e-mail will break it up, > and the syntax is kindof picky -- xargs is a great tool, even if it is a > little farkled): > > psql -t -c "select datname from pg_database" template1|xargs -n 1 psql > -q -c "vacuum analyze

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

> 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 sockets, but I may be wr

Re: [ADMIN] Bugs ? Partition filling up with PostgreSQL 6.4.2 and 6.5

> Now, I updated the database installation to the last 6.5 release, > hoping that it would fixed the bugs but no. The same thing > happen except now that other query to the used-to-be-locked table > now complete (thanks to the new MVCC!) Also it is now pg_temp.X > files which are eating all th

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

> Hi, I have installed (tnx to everyone) postres 6.5. Now I must to wrap the > port 6542 so no one extern to my machine can telnet the postgres DB. > Any help or any RTFM? 5432, you mean. If you don't use -i flag to postmaster, it will never listen on any tcp/ip port. It uses only unix domain s

[ADMIN] src/pl/tcl/mkMakefile.tcldefs.sh.in

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: TCL_SHLIB_LD='ld -shared -expect_unresolved "*"' >From mkMakefile.tcldefs.sh.in cat @TCL_

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

Hello What is port 6542 ? Best Regards Roger Leck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 08, 1999 10:13 PM To: [EMAIL PROTECTED] Subject: [ADMIN] wrap a port for v6.5 Hi, I have installed (tnx to everyone) postres 6.5. Now I must

[ADMIN] NEW WEB INTERFACE for PostgreSQL

Hi all, sorry if get this mail 2 or 3 times! I am working on a CGI (perl) to access ANY postgres DB from the web: "PGase" Here are the main features: _ Login page to enter the CGI (default guest OK!). _ Select/Insert/Update/Delete with just the mouse. (foreign keys are links to primary

[ADMIN] regular maintenance, backup

Keith Keller wrote: > > I run a perl script that selects the existing databases from, uh, > pg_database, I think, and then runs a vacuum command on > each. It's klunky, but it works. If anyone is interested, let > me know and I'll post and/or mail it. (It uses the perl Pg > module, whic

Re: [ADMIN] regular maintenance, backup

Lamar Owen wrote: > [snip] > > 2) how do i schedule a regular vacuum through cron? do you not have to be > > in psql to do a vacuum? or can you do it from the bash prompt? (we are > > using linux rh 5.2, kernel 2.2.2, postgres 6.4.2) > > Again, my crontab (sub your database name for "intran

Re: [ADMIN] regular maintenance, backup

JT Kirkpatrick wrote: > 1) we have a second hd in the system that can be used as a backup device, > in addition to a tape. i had planned to simply copy the directory via a > tar command run through cron. is that the best way, or should i consider a > pg_dump (which i know nearly nothing about

[ADMIN] regular maintenance, backup

ok, the company (www.mpsllc.com) is now completely on postgres with primarily access97 front-end (we are working on some perl/cgi scripts to interact w/ the database over an intranet also) -- 20 users. i have reported hanging up problems to this group, but those haven't recurred since we took

[ADMIN] Error starting Postmaster

Hi my name is Erik, I have some problems running Postmaster. I use Solaris 2.7 Intel and Postgres 6.5 When i try to start the Postmaster I get the following Errormessage: IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=1063936, permission=600 FATAL 1: ShmemCreate: cannot c

Re: [ADMIN] cyrillic

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 environment. As ususal in russia some users prefer > KOI8-R

[ADMIN] cyrillic

Hi! Please explain me: Can user choose its locale while fetching data from postgresql (6.5)? What I mean: I have PGSQL in multiuser environment. As ususal in russia some users prefer KOI8-R but other prefer CP-1251 code pages... :-( Sounds good to make SET CODEPAGE='...' operator to change PGSQ

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

Oleg Broytmann wrote: > >There is no way. Either disable TCP/IP or use HBA. When using TCP/IP + HBA, > Postgres will listen on its TCP/IP port, and telnetting is always possible. > HBA helps to restrict access to databases, but not to TCP/IP port. > >You can try to configure firewall on

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

On Thu, 8 Jul 1999, ZioBudda wrote: > 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. There is no way. Either disable TCP/IP or use

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

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. Pensa alla vita: usa le cinture di sicurezza. -- Michel Morelli [EMAIL PROTECT

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

On Thu, 8 Jul 1999, ZioBudda wrote: > On Thu, 8 Jul 1999, Oleg Broytmann wrote: > >Run Postgres with TCP/IP disabled (remove -i from start-up options) and > > use UNIX sockets to connect to postgres (you don't need anything special - > > libpq knows how to handle this situation). > I have t

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

On Thu, 8 Jul 1999, ZioBudda wrote: > Hi, I have installed (tnx to everyone) postres 6.5. Now I must to wrap the > port 6542 so no one extern to my machine can telnet the postgres DB. > Any help or any RTFM? Run Postgres with TCP/IP disabled (remove -i from start-up options) and use UNIX socke

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

On Thu, 8 Jul 1999, Oleg Broytmann wrote: > On Thu, 8 Jul 1999, ZioBudda wrote: > > Hi, I have installed (tnx to everyone) postres 6.5. Now I must to wrap the > > port 6542 so no one extern to my machine can telnet the postgres DB. > > Any help or any RTFM? > >Run Postgres with TCP/IP disabl

[ADMIN] Bugs ? Partition filling up with PostgreSQL 6.4.2 and 6.5

Hi, I'm the database administrator here for a postgresql installation. I have had several database applications running with no problems but I have run into a severe problems with a client's application which we are hosting. We used postgresql 6.4.2 under a RH 6.0 like environment. I don't know

[ADMIN] wrap a port for v6.5

Hi, I have installed (tnx to everyone) postres 6.5. Now I must to wrap the port 6542 so no one extern to my machine can telnet the postgres DB. Any help or any RTFM? Le uniche cose che girano sotto Windows 95 sono le palle. -- Michel Morelli [EMAIL PROTECTED]