- Original Message -
From: "Judy Jecelin"
>
> Hi,
>
> A relatively novice user of PostgreSQL but not
> of other databases... I'm trying to understand the
> use of initlocationI understand having separate
> data storage areas (perhaps for each database
> in your postmaster), but is th
Hi,
A relatively novice user of PostgreSQL but not
of other databases... I'm trying to understand the
use of initlocationI understand having separate
data storage areas (perhaps for each database
in your postmaster), but is there some way to have
a separate location for indexes? How would
That was a bad move ... but you might be able to recover, at least in
part, by running contrib/pg_resetxlog.
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
sub
"Gill, Jeffrey L" <[EMAIL PROTECTED]> wrote:
> Is Postgresql multithreaded i.e can it take advantange of multiprocessor
> systems (4 ways)? Is Interchange written as multithreaded application?
> What is the most processors you have seen Postgresql running on?
Our server is a Dell with 4 process
Dear all,
I am trying to restore a backup of database created by
pg_dump. But I got the following error, no matter I
use command a or b.
Why pg_restore try to create stuff while data only
option is given?
--- log ---
command (a)
su -l pgsql -c "pg_restore -d db01
/export/data/subsys/backend/ar
At 07:00 AM 3/26/2002 , [EMAIL PROTECTED] wrote:
>Warning: Unable to connect to PostgreSQL server: connectDBStart() --
>connect()
>failed: Connection refused Is the postmaster running (with -i) at 'dionisio'
>and accepting connections on TCP/IP port 5432?
So =is= your postmaster running with a '
[EMAIL PROTECTED] writes:
> Hello.
> I wonder if you could help me? When i tried to make a connection to my database
> Postgres by TCP/IP the following ocurred:
>
> Warning: Unable to connect to PostgreSQL server: connectDBStart() -- connect()
> failed: Connection refused Is the postmaster runnin
At 10:56 AM 4/1/2002 , Gill, Jeffrey L wrote:
>Is Postgresql multithreaded i.e can it take advantange of multiprocessor
>systems (4 ways)?
Not presactly multithreaded, but since every connection to the database
gets its own backend process, PostgreSQL will make use of multi processors
as long a
I have a pg_dump file which contains only schemas,
I think there is a bug, which causes function reload
fail, look at following pieces of dump file:
..
..
--
-- TOC Entry ID 212 (OID 34744710)
--
-- Name: gibson Type: TABLE Owner: jliang
--
CREATE TABLE "gibson" (
"cid" integer,
On Fri, 29 Mar 2002, Nicholay P. Chuprynin wrote:
>
> Hello, All!
> Resently I had to create and manage the (relatively) large table.
> In the mean time it's about 8 million rows, and surely will grow above
> this size.
> The problem is that queries takes absolutely not acceptable time.
> Databa
and now I ve got ...
DEBUG: database system was shut down at 2002-03-29 09:37:28 CET
DEBUG: open(logfile 15 seg 167) failed: Nie ma takiego pliku ani katalogu
DEBUG: Invalid primary checkPoint record
DEBUG: open(logfile 15 seg 165) failed: Nie ma takiego pliku ani katalogu
DEBUG: Invalid se
Hello all.
I'v migrated my data to 7.2.
Now I'm testing aplications, but looks like timestamp function in
postgres is broken:
klienti=# select date(now());
date
2002-03-27
(1 row)
klienti=# select timestamp(date(now()));
ERROR: parser: parse error at or near "date"
I need t
Hello.
I wonder if you could help me? When i tried to make a connection to my database
Postgres by TCP/IP the following ocurred:
Warning: Unable to connect to PostgreSQL server: connectDBStart() -- connect()
failed: Connection refused Is the postmaster running (with -i) at 'dionisio'
and acce
13 matches
Mail list logo
