On Sep 18, 7:03 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
> Bernt Drange escribió:
>
> > After a lot of fiddling with being able to enter single user mode on a
> > windows machine (I had to figure out how to run the command line as
> > the correct user, then for some reason -D didn't work, but
Hello.
I am having some trouble restoring a dump from the production system
over to a test system. Both servers are 8.2.5 and both use UTF-8. The
vrc_error table have ~36 mill rows on the production system, but none
of those are restored to the test system.
pg_restore: [archiver (db)] Err
Hello PG Community,
Does PG uses multiple processors/cores if available by default on various
OSes? What are the limitations on using multiple processors/cores and main
memory?
Thanks
CPK
On Fri, Sep 19, 2008 at 6:29 PM, Tore Halset <[EMAIL PROTECTED]> wrote:
> Looks like I have managed to insert an illegal character into the main
> system that does not conform to UTF-8. Anything I can and should do to work
> around this issue?
I have had the same problem previously and after a lot
>>> "c k" <[EMAIL PROTECTED]> wrote:
> Does PG uses multiple processors/cores if available by default on
various
> OSes?
A separate process is created to handle each connection. You don't
get much benefit from multiple processors if only one connection at a
time is running a query, but in a n
On Fri, Sep 19, 2008 at 5:55 AM, c k <[EMAIL PROTECTED]> wrote:
> Hello PG Community,
> Does PG uses multiple processors/cores if available by default on various
> OSes?
Yes, see attached top extract from my primary db server at work
> What are the limitations on using multiple processors/cores a
On Fri, Sep 19, 2008 at 2:26 AM, Bernt Drange <[EMAIL PROTECTED]> wrote:
> On Sep 18, 7:03 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
>> Bernt Drange escribió:
>>
>> > After a lot of fiddling with being able to enter single user mode on a
>> > windows machine (I had to figure out how to run the
On Fri, September 19, 2008 07:39, Scott Marlowe wrote:
> On Fri, Sep 19, 2008 at 2:26 AM, Bernt Drange <[EMAIL PROTECTED]> wrote:
>> On Sep 18, 7:03 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
>>> Bernt Drange escribió:
>>>
>>> > After a lot of fiddling with being able to enter single user mode o
Hi All;
I've gone into contribs/pg_buffercache and run this:
make (as postgres)
make install (as root)
psql -f pg_buffercache.sql
when I run the psql command against my database I get this:
BEGIN
SET
psql:pg_buffercache.sql:9: ERROR: could not access file "$libdir/
pg_buffercache": No such
ok so I have more info.
a pg_config --libdir shows me /usr/lib64
however the make install installs the pg_buffercache in /pgmoveable/
lib/postgresql
Thoughts ?
On Sep 19, 2008, at 3:51 PM, kevin kempter wrote:
Hi All;
I've gone into contribs/pg_buffercache and run this:
make (as post
kevin kempter wrote:
> ok so I have more info.
>
>
> a pg_config --libdir shows me /usr/lib64
>
> however the make install installs the pg_buffercache
> in /pgmoveable/lib/postgresql
>
>
How was postgresql installed on the machine in the first place? RPM?
DEB? Just guessing by the pg_config outp
On Sep 19, 2008, at 4:18 PM, Jeff Frost wrote:
kevin kempter wrote:
ok so I have more info.
a pg_config --libdir shows me /usr/lib64
however the make install installs the pg_buffercache in /pgmoveable/
lib/postgresql
How was postgresql installed on the machine in the first place?
>>>
>>> a pg_config --libdir shows me /usr/lib64
>>>
>>> however the make install installs the pg_buffercache
>>> in /pgmoveable/lib/postgresql
>>>
>>>
>>
>> How was postgresql installed on the machine in the first place? RPM?
>> DEB? Just guessing by the pg_config output, I'd say postgresql was
13 matches
Mail list logo
