headers
Reynard Hilman | 1 Apr 2003 01:26

Re: connect to postgres server without internet connection

>
>
>Yes, php its doing this by default (no hostname in the connect string)
>on my linux box.
>
>Greetings,
>-tb
>  
>
Yes, it works. I didn't expect the answer is that simple.
thanks everyone,

- reynard

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Permalink | Reply | 0 comments |
headers
DeJuan Jackson | 1 Apr 2003 01:58

Re: System lockup

The boxes that I've tested and gotten this problem on are as different 
as night and day, it's easier to sum up the similarities [they are all 
SMP systems with 2 processors (so your BIOS suggestion might fix things, 
I'll try to take a look the next time one of them drops)].
  I'm not sure if their BOIS/chipset maker is the same or not (Ones a 
DELL and the others an IBM).

scott.marlowe wrote:

>I use RH 7.2 for VERY heavy database/apache/ldap load and it never ever 
>locks up.  How's your setup for things in the BIOS?  I've found that 
>settings like SMP mode 1.1 versus 1.4 in some BIOSes makes a difference 
>(lockups with 1.1, works fine in 1.4).  I'd take a look at what's common 
>on the boxes hardware wise, i.e. NICs, motherboards, video cards, hard 
>drives, scsi controllers, BIOS settings for the PCI bus or memory speed 
>etc...
>  
>

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Permalink | Reply | 2 comments |
headers
scott.marlowe | 1 Apr 2003 02:18
Favicon

Re: System lockup

Yeah, I've been surprised how many times things like this are caused by 
having the same person setup the machines making the same assumptions.
Especially the number of times it been me setting up the machines. :-)

Also, look for things like kernel settings that may be causing this kind 
of problem.  I've seen a lot of issues with dma settings, or odd cards.  
do they share the same kind of, say, nics or raid controllers?  Could be a 
common bug in a driver there too.  Good luck on finding and fixing it...

On Mon, 31 Mar 2003, DeJuan Jackson wrote:

> The boxes that I've tested and gotten this problem on are as different 
> as night and day, it's easier to sum up the similarities [they are all 
> SMP systems with 2 processors (so your BIOS suggestion might fix things, 
> I'll try to take a look the next time one of them drops)].
>   I'm not sure if their BOIS/chipset maker is the same or not (Ones a 
> DELL and the others an IBM).
> 
> scott.marlowe wrote:
> 
> >I use RH 7.2 for VERY heavy database/apache/ldap load and it never ever 
> >locks up.  How's your setup for things in the BIOS?  I've found that 
> >settings like SMP mode 1.1 versus 1.4 in some BIOSes makes a difference 
> >(lockups with 1.1, works fine in 1.4).  I'd take a look at what's common 
> >on the boxes hardware wise, i.e. NICs, motherboards, video cards, hard 
> >drives, scsi controllers, BIOS settings for the PCI bus or memory speed 
> >etc...
> >  
> >
>
(Continue reading)

Permalink | Reply | 1 comment |
headers
Marc G. Fournier | 1 Apr 2003 02:23
Favicon

Re: Replication Status


http://www.erserver.com is the newest, much improved, incarnation ... much
simpler installation and adminstration, and does multi-slave ...

On Mon, 31 Mar 2003, Tim Perdue wrote:

> I was using rserv about two years ago, but it wasn't terribly efficient.
> Has rserv or any other replication solution improved much?
>
> I would appreciate any opinions and links, as I'm not pulling up much
> recent info in the list search.
>
> Thanks,
>
> Tim
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html
Permalink | Reply | 0 comments |
headers
Tom Lane | 1 Apr 2003 03:24
Picon

Re: System lockup

"scott.marlowe" <scott.marlowe <at> ihs.com> writes:
> Also, look for things like kernel settings that may be causing this kind 
> of problem.

Ny ears pricked up immediately at the mention of SMP.  Look hard for
kernel errata affecting SMP, driver problems, etc.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org
Permalink | Reply | 0 comments |
headers
Jean-Christian Imbeault | 1 Apr 2003 04:01
Picon

Newsgroups/sites for SQL questions?

After having gotten my DB up and running and doing what it should I am 
now getting to the point where I understand my data and have some 
somewhat complicated queries I would like to run against it.

Unfortunately I'm having trouble with coming up with the SQL queries 
that retrieve the data I want.

Can anyone recommend some newsgroups or sites where questions on 
constructing SQL queries are welcomed?

Since these would be purely SQL questions and not really related to 
postgres I they don't really belong on the PG mailing list.

Thanks!

Jean-Christian Imbeault

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo <at> postgresql.org)
Permalink | Reply | 3 comments |
headers
David Busby | 1 Apr 2003 04:38
Favicon

Log the SQL Statements

List,
    How do I configure PostgreSQL to log all inbound SQL queries/statements?
I've been up and down through debug levels, and other config stuff but can't
find it.  Any ideas?

/B

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo <at> postgresql.org)
Permalink | Reply | 3 comments |
headers
Bruce Momjian | 1 Apr 2003 05:07
Picon

Re: Log the SQL Statements


In 7.3, it is log_statement.

---------------------------------------------------------------------------

David Busby wrote:
> List,
>     How do I configure PostgreSQL to log all inbound SQL queries/statements?
> I've been up and down through debug levels, and other config stuff but can't
> find it.  Any ideas?
> 
> /B
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo <at> postgresql.org)
> 

--

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman <at> candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Permalink | Reply | 2 comments |
headers
Ian Barwick | 1 Apr 2003 08:00
Picon

Re: Newsgroups/sites for SQL questions?

On Tuesday 01 April 2003 04:01, Jean-Christian Imbeault wrote:
> After having gotten my DB up and running and doing what it should I am
> now getting to the point where I understand my data and have some
> somewhat complicated queries I would like to run against it.
>
> Unfortunately I'm having trouble with coming up with the SQL queries
> that retrieve the data I want.
>
> Can anyone recommend some newsgroups or sites where questions on
> constructing SQL queries are welcomed?

How about the the pgsql-sql list?

For newsgroups have a look at comp.databases and comp.databases.theory .

Ian Barwick
barwick <at> gmx.net

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo <at> postgresql.org)
Permalink | Reply | 0 comments |
headers
Nigel J. Andrews | 1 Apr 2003 09:29
Picon

lo_copy()


I wonder if anyone has any comments on this [psuedo] code:

new loid := SELECT lo_creat(131072 + 262144);

UPDATE pg_largeobject SET
	data = (SELECT data
			FROM pg_largeobject
			WHERE loid = <source loid> AND pageno = 0)
	WHERE loid = <new loid> AND pageno = 0;

INSERT INTO pg_largeobject
	(loid, pageno, data)
	(SELECT <new loid>, pageno, data
		FROM pg_largeobject
		WHERE loid = <source loid> AND pageno > 0
	);

It does seem to work but I wouldn't like to swear it's safe, hence this
posting.

I was originally looking for a newoid() function to use, then thought about
wrapping my own seeing as there wasn't one but then spotted there were some lo_
functions available. Therefore, lo_creat() I'm really just using to grab a new
oid for the new large object.

--

-- 
Nigel J. Andrews

---------------------------(end of broadcast)---------------------------
(Continue reading)

Permalink | Reply | 2 comments |

Gmane