[ADMIN] Newbie question about pg_xlog

2002-10-21 Thread Stein, Jochen
Hello! I just set up a little test database and i asked myself why this pg_xlog-directory has already 33MBs and is still growing. Is there a "natural" limitation for the size of (the files in) this directory? (I know: disc space! ;-)but what i meant: a limitation thru the postmater.) Or did

Re: [ADMIN] Cannot reference system table

2002-10-21 Thread Tom Lane
Casey Allen Shobe <[EMAIL PROTECTED]> writes: > create table "schemes" ( > ... > "user_id" integer not null references "pg_user" ("usesysid"), > ... > ERROR: Referenced relation "pg_user" is not a table > As you can hopefully see, I need to reference the postgres user table >

[ADMIN] Cannot reference system table

2002-10-21 Thread Casey Allen Shobe
create table"schemes" ( "id"integer not null unique default nextval('schemes_scheme_id_seq'), "user_id" integer not null references "pg_user" ("usesysid"), "scheme_name" varchar(32) not null unique, "expired" boolean

Re: [ADMIN] Interesting date/time 60 second problem with Postgresql

2002-10-21 Thread Tom Lane
Will LaShell <[EMAIL PROTECTED]> writes: > psql:/mnt/nfs/sql/replication_test.sql:603812: ERROR: copy: line 44060, > Bad timestamp external representation '2002-10-07 09:55:60.00-07' > I know there were time accuracy fixes put in, was this something that > was fixed? Yeah, this is an old bug. Y

[ADMIN] Interesting date/time 60 second problem with Postgresql

2002-10-21 Thread Will LaShell
We are in the process of moving an emergency servers old data from Postgresql 7.1 to 7.2 and I got a very odd ( read as sucky ) error when I went to psql -f the dump file. psql:/mnt/nfs/sql/replication_test.sql:603812: ERROR: copy: line 44060, Bad timestamp external representation '2002-10-07 0

Re: [ADMIN] Using oid with RServ w/ Postgresql 7.2

2002-10-21 Thread Tom Lane
Will LaShell <[EMAIL PROTECTED]> writes: > On Thu, 2002-10-17 at 18:55, Tom Lane wrote: >> This is risky for a long-lived database. Things will work fine until >> the OID counter wraps around (ie, more than 4 billion rows inserted >> into your database). After that you have a risk of OID collisio

Re: [ADMIN] newbie qs; fixing and checking databases

2002-10-21 Thread Shawn Michael
On 2002.10.16 00:34 Nigel J. Andrews wrote: > On Tue, 15 Oct 2002, Tom Lane wrote: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > Rusty Wright wrote: > > >> Are there commands provided with postgresql for checking the databases > > >> and also for repairing them? > > > > > We don't have ch

Re: [ADMIN] newbie qs; examining databases and tables

2002-10-21 Thread Rusty Wright
Ok, thanks. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] How to get user names and passwords

2002-10-21 Thread Josh Goldberg
\d pg_ and tab to get the list of system tables. - Original Message - From: "zhaoyong wu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 18, 2002 1:06 PM Subject: [ADMIN] How to get user names and passwords > Hi, > I created a database and create some users and passwo

Re: [ADMIN] Using oid with RServ w/ Postgresql 7.2

2002-10-21 Thread Will LaShell
On Thu, 2002-10-17 at 18:55, Tom Lane wrote: > Will LaShell <[EMAIL PROTECTED]> writes: > > My question would then be, are there any problems/reasons or hints with > > using the oid field as the field that the rserv trigger is set on? > > We will be using rserv in a production environment so I'm lo