"Brian Baquiran" <[EMAIL PROTECTED]> writes:
> How long should I expect WAL files in $PGDATA/pg_xlog to hang around?
It depends. How long are your transactions?
The current algorithm is for each checkpoint to discard log data before
the start of the oldest transaction that was open during the l
Thx for your help
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of
> Vince Vielhaber
> Sent: Monday, March 26, 2001 9:41 PM
> To: Christian Marschalek
> Cc: 'Peter Eisentraut'; [GENERAL] PostgreSQL
> Subject: RE: [GENERAL] PostgreSQL under Windows
Make a column of type SERIAL. See
http://www.postgresql.org/docs/aw_pgsql_book/node88.html
- Original Message -
From: "Jeff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 6:20 PM
Subject: [GENERAL] How to auto create a unique key for each newly added
record?
>
Is there a way to extract the coordinates from a point datatype? I'd like
to do something like
select x_coord(pnt), y_coord(pnt) from table_with_points;
And if there is a way to extract the points from a polygon that would be
great too.
I looked through the results of \df and \do, and it ap
Oops! Sorry.
7.0.2 and Linux.
The database is accessed from a VB5 app via ODBC.
Stephen
On Mon, 26 Mar 2001 21:38:09 -0600, Larry Rosenman said:
> * Stephen Davies <[EMAIL PROTECTED]> [010326 21:36]:
> > Hello again.
> >
> > I have just had to restore a database from backup because the majori
* Stephen Davies <[EMAIL PROTECTED]> [010326 21:36]:
> Hello again.
>
> I have just had to restore a database from backup because the majority
> of records in one table had "magically" become null.
>
> Last Friday morning there were some 700 valid rows in the table but yesterday
> all but 42 h
On Mon, 26 Mar 2001 21:21:12 -0500
"Jeff" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Can some one show me what's the best way to backup a table or copy a table?
Backing up is simple with pg_dump and pg_dumpall.
Copying a table (assuming within the same database) is also easy:
create table test as s
On Mon, 26 Mar 2001 21:20:13 -0500
"Jeff" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> How to if it is possible to let postgresql to auto assign unique key to each
> new record that is added to the database?
>
Just set up the table with the field you are wanting to have as a unique id as type
"serial"
Hello again.
I have just had to restore a database from backup because the majority
of records in one table had "magically" become null.
Last Friday morning there were some 700 valid rows in the table but yesterday
all but 42 had become totally null.
Restoring from Thursday night's backup rep
Hi all
Thanks to everyone for this great forum, and for Postgres!
I have a couple of questions:
I have a smallish table which I join on another (smaller) table. I have
created a view for this purpose, thinking it would save on overhead.
The view also incorporates some calculated fields. However
Hi,
How to if it is possible to let postgresql to auto assign unique key to each
new record that is added to the database?
Thanks
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/fa
Hi,
Can some one show me what's the best way to backup a table or copy a table?
Thanks
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
How long should I expect WAL files in $PGDATA/pg_xlog to hang around?
Last night I loaded up around 8GB of data and in the morning I there were
118 files in $PGDATA/pg_xlog. They didn't go away until after I shutdown and
restarted the database and I saw a bunch of "DEBUG: MoveOfflineLogs: remove
Hi,
what is the best method to make concurrent inserts to a table with
unique/primary key?
Scenario:
I write a DBI logger for Apache, and this uses a table for all referers:
CREATE TABLE referer (
id SERIAL,
referer varchar(2048) NOT NULL PRIMARY KEY
);
so, you can im
On Mon, 26 Mar 2001, Scott Gritton wrote:
> I've installed postgresql on a Linux-Mandrake 7.0.2 box with everything
> installing correctly.
> But when I try to start postmaster I get the following:
>
> DEBUG: Data Base System is in production state at Mon Mar 26 (and so forth)
>
> I know that the
On Monday 26 March 2001 03:49 pm, Doug McNaught wrote:
> "Scott Gritton" <[EMAIL PROTECTED]> writes:
> > I've installed postgresql on a Linux-Mandrake 7.0.2 box with everything
> > installing correctly.
> > But when I try to start postmaster I get the following:
> >
> > DEBUG: Data Base System is
Anyone know the max username/password length for Postgres?
--
Adam Haberlach|
[EMAIL PROTECTED] | http://youlook.org
http://www.newsnipple.com |
'88 EX500'00 >^< |
---(end of broadcast)---
TIP 6: Have you search
"Scott Gritton" <[EMAIL PROTECTED]> writes:
> I've installed postgresql on a Linux-Mandrake 7.0.2 box with everything
> installing correctly.
> But when I try to start postmaster I get the following:
>
> DEBUG: Data Base System is in production state at Mon Mar 26 (and so forth)
>
> I know that
I've installed postgresql on a Linux-Mandrake 7.0.2 box with everything
installing correctly.
But when I try to start postmaster I get the following:
DEBUG: Data Base System is in production state at Mon Mar 26 (and so forth)
I know that there is a simple answer but I haven't been able to find i
On Mon, Mar 26, 2001 at 05:18:01PM +0200, [EMAIL PROTECTED] wrote:
> On 26 Mar 2001, at 3:42, Gary Huntress wrote:
>
> > I am looking for PostgreSQL users to beta test the following free database
> > hosting service:
> >
> > http://superid.dyndns.org:8080/freesql/index.php
> >
> > I've done
On Mon, Mar 26, 2001 at 03:42:43AM +, Gary Huntress wrote:
> I am looking for PostgreSQL users to beta test the following free database
> hosting service:
>
> http://superid.dyndns.org:8080/freesql/index.php
>
> I've done a fair amount of testing myself, but I need a few more people to
>
Greetings All,
At PostgreSQL Inc. we wish to expand our elephant gear product line.
Your input would be greatly appreciated so please surf over to
http://www.pgsql.com
And take our quick poll on what you would like to see for sale on our site.
Thanks Everyone.
Jeff MacDonald,
--
Kevin L <[EMAIL PROTECTED]> writes:
> Hi. I'm running Postgres 6.5.3 and want to add a column with
> "default 0" to an existing table.
Try updating to something more recent ...
regards, tom lane
---(end of broadcast)---
TIP
On Mon, 26 Mar 2001, Christian Marschalek wrote:
> Hm... I can only find how to compile the libraries under visual c++
http://www.postgresql.org/related.html
Vince.
>
> regards
>
> > -Original Message-
> > From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, March 26, 2
Seems interesting. We already have \c overloaded with stuff like
connect, copy, and copyright, so I guess another one wouldn't hurt. I
will keep this for 7.2. Thanks.
[ Charset ISO-8859-1 unsupported, converting... ]
>
> (Sorry for the repost. I have amended my previous patch
> with feedbac
Hi. I'm running Postgres 6.5.3 and want to add a column with
"default 0" to an existing table.
alter table add column col int4 default 0;
does not work. I've also tried modifying the system table,
pg_attrdef, but that does not work either. I don't want to drop
and recreate the table.
Any ideas
Christian Marschalek writes:
> Is it possible to compile and run PostgreSQL under Windows2000 ?
Yes. See installation instructions. (Requires Cygwin.)
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
---(end of broadcast)--
Is it possible to compile and run PostgreSQL under Windows2000 ?
TIA
Legshot
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
(Sorry for the repost. I have amended my previous patch
with feedback that outputs the new current directory.)
Here's a patch for a \cd (change dir) command in psql program.
It's very small and only adds a few lines.
Personally, I am surprised psql does not have this command.
It is EXTREMELY us
Good point - thanks for the advice
(Tom - where *do* you get the time to answer everyones questions? :o)
Regards,
Phil
+--+
| Phil Mayers, Network Support |
| Centre for Computing Services|
| Imperial College |
+---
hi,
i have just created a new database. I would like to add, now, a new
user. The user can make any changes in THIS database (no one else).
i used: (from NEW database)
create user new_user with password "new_pass";
i try to connect to another database with this new_user and i
Alexander Lohse <[EMAIL PROTECTED]> writes:
> What would I need to do to run 2 Versions of Postgres on the RaQ3?
Should be the same deal as for running 2 versions anyplace else:
give them separate install directories, separate data directories,
and separate port numbers. If you compile from sour
32 matches
Mail list logo