Is there any way to remove a password, specifically from the postgres
user? I installed the 8.0 Windows version via the installer, and it
forces you to set a password. I'd like to reset this so that there is
no password (basically, to match the setup on several other machines -
and no, for a numb
On Wed, 13 Oct 2004, Aaron Glenn wrote:
What is the PostgreSQL project's official stance/view/comment on this?
Should we have one? And why?
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
I would like to
unsubscribe my address from the mailing list, please advise how to go about
this?
Regards
Joseph
Aaron Glenn wrote:
> What is the PostgreSQL project's official stance/view/comment on this?
Uh, I work for SRA, but the community has always stated that the project
can not certify anyone. Just like the Linux kernel group doesn't
certify anyone, Red Hat and other companies do, the same is true of
Hello,
I am trying to create audit tables for all of the tables in my
database. The function, table and trigger create statements are below.
Apparently, I am not doing it quite right, because I get these messages
when I try to run the create statements below:
CREATE FUNCTION
CREATE FUNCTION
CRE
First, apologies in advance for this somewhat OT post ...
I'm looking for a source of information on using the psycopg
interface to postgresql. A mailing list would be ideal. I've
poked at their wiki, but not found what I'm looking for.
Also, new to both postrgresql & psycopg, my questions appear
Scott Cain <[EMAIL PROTECTED]> writes:
> I am trying to create audit tables for all of the tables in my
> database. The function, table and trigger create statements are below.
> Apparently, I am not doing it quite right, because I get these messages
> when I try to run the create statements belo
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] ("Joshua D.
Drake") transmitted:
> Slony replicates data every (10?) transactions.
No, Slony-I replicates each and every transaction that it processes,
identifying it as a transaction independent of others.
In practice, it i
What is the PostgreSQL project's official stance/view/comment on this?
aaron.glenn
On Thu, 14 Oct 2004 10:48:26 +0900 (JST), Tatsuo Ishii
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> We, Software Research Associates, Inc., have started "PostgreSQL CE"
> (PostgreSQL Certificated Engineer), on Oct 1
Hi all,
We, Software Research Associates, Inc., have started "PostgreSQL CE"
(PostgreSQL Certificated Engineer), on Oct 1st. PostgreSQL CE is an
entry level PostgreSQL engineer certification program. We expect at
least several hundreds of people will take the examin by April
2005. We also hope tha
Thanks to Patrick and Richard for pointing out timeofday(); I was
imagining that I'd have to do some server-side-code magic to get that.
But I'm still hoping that someone will have a better solution - using
this I still need a near-global lock between setting the timestamps and
committing the t
On Wed, 13 Oct 2004, Joshua D. Drake wrote:
Hello,
There are two heavily supported and active replication projects.
1. Slony - http://www.slony.info
2. Mammoth Replicator - http://www.commandprompt.com/
Three, actually ...
3. eRServer - http://www.pgsql.com
We're currently working on the next ver
Steve Wolfe <[EMAIL PROTECTED]> writes:
>So, I did "dd if=/dev/zero of=/usr/local/pgsql/data/pg_clog/0089
> bs=8k count=1". I did an ls to verify that the file existed. I started
> the postmaster back up, tried a VACUUM, and got:
> vacuumdb: vacuuming of database "hyperseek" failed: ERROR:
I'm in the process of adding more historic information to one of my
databases. I've liked the theoretical treatment of the concept in
"Temporal Data and the Relational Model", by Date, Darwen, & Lorentzos.
A lot of it is not realizable without a lot of user defined
types/functions/etc. I was
Hi Gaetano:
This procedure to recover data from a corrupted table should be
documented somewhere... If it is, I could not find it!
Now I wonder if I have lost any data, because after creating the
pg_clog/0004 and running VACCUM everything seems ok.
Thanks a lot for your help.
Ruben.
Gaetano Men
Hi
I'm trying to create a select statement that will return all rows that
are older than 30 milleseconds. Is either of these correct?
select event_id from event where (current_timestamp-timestamp)>.030
or
select event_id from event where
(current_timestamp-timestamp)>00030.00
thanks,
Phi
Michael Fuhr wrote:
On Wed, Oct 13, 2004 at 01:32:01PM -0400, David Rysdam wrote:
Michael Fuhr wrote:
You could filter the data through a script that reformats certain
fields, then feed the reformatted data to PostgreSQL. This is
usually a trivial task for Perl, awk, sed, or the like.
Right, I *can* do this. But then I have to build knowledge into that
script so it can find each of these date fields (there's like 20 of them
across 10 different files) and then update that knowledge each time it
changes.
In your case that's a reasonable argument against filtering the
data with a
Here is a good overview.
http://jeremy.zawodny.com/blog/archives/000846.html
Note that http://pgreplicator.sourceforge.net/ is a
multi-master solution using TCL. Despite the dire
home page, it is "actively" supported. However, our
experience with it was that it was not industrial
strenght. W
On Wed, Oct 13, 2004 at 01:32:01PM -0400, David Rysdam wrote:
> Michael Fuhr wrote:
> >You could filter the data through a script that reformats certain
> >fields, then feed the reformatted data to PostgreSQL. This is
> >usually a trivial task for Perl, awk, sed, or the like.
> >
> Right, I *can*
Hello,
There are two heavily supported and active replication projects.
1. Slony - http://www.slony.info
2. Mammoth Replicator - http://www.commandprompt.com/
Slony is Open Source and uses triggers and a replication schema to
replicate data.
Mammoth Replicator is commercial and uses a transaction
On Wed, 2004-10-13 at 10:59 -0700, Robby Russell wrote:
> On Wed, 2004-10-13 at 20:02 +0200, [EMAIL PROTECTED] wrote:
> > Hello
> >
> > I am going to do a comparison betweem PgSQL and MySQL replication system.
> >
> > I hear there are some replication projects available for PgSQL. Which are
> >
On Wed, 2004-10-13 at 20:02 +0200, [EMAIL PROTECTED] wrote:
> Hello
>
> I am going to do a comparison betweem PgSQL and MySQL replication system.
>
> I hear there are some replication projects available for PgSQL. Which are
> still active and serious, because I hear that some are not active or
>
Hello
I am going to do a comparison betweem PgSQL and MySQL replication system.
I hear there are some replication projects available for PgSQL. Which are
still active and serious, because I hear that some are not active or
incomplete?
Will any of these projects be merged with PgSQL soon?
I app
Greg Stark wrote:
David Rysdam <[EMAIL PROTECTED]> writes:
In my brute force port, I just bulk copied the date
fields into temporary tables and then did a to_timestamp(field, 'Mon DD
HH:MI:SS:MSAM').
Again, I created a temporary table and did a decode(field, 'hex') to the
real tabl
Michael Fuhr wrote:
On Wed, Oct 13, 2004 at 10:06:58AM -0400, David Rysdam wrote:
Sybase bulk copies the date fields out in this format:
Mar 4 1973 10:28:00:000AM
Postgresql's COPY (or psql \copy) doesn't like that format.
You could filter the data through a script that reformats certain
f
On Wed, Oct 13, 2004 at 10:06:58AM -0400, David Rysdam wrote:
> Sybase bulk copies the date fields out in this format:
>
> Mar 4 1973 10:28:00:000AM
>
> Postgresql's COPY (or psql \copy) doesn't like that format.
You could filter the data through a script that reformats certain
fields, then fe
On Wed, 2004-10-13 at 11:17 -0400, Alexander Cohen wrote:
> Hi,
>
> Im looking for instructions on installing the postgresql ODBC driver on
> mac osx and windows. Is there any reference for that. Any help is
> apprecitaed. BTW, i need to compile it and install it wihtout using the
> windows ins
David Rysdam <[EMAIL PROTECTED]> writes:
> In my brute force port, I just bulk copied the date
> fields into temporary tables and then did a to_timestamp(field, 'Mon DD
> HH:MI:SS:MSAM').
> Again, I created a temporary table and did a decode(field, 'hex') to the
> real table.
This is the
In reference to the pg_clog errors I'm having, I am still looking for
tips or help. Here's the info again:
"ERROR: could not access status of transaction 143934068
DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0089": No
such file or directory
Now, despite creating an 8k fil
Greg Stark <[EMAIL PROTECTED]> writes:
> I can't think of a good approach for migration of old pg_dumps though, so
> perhaps this is more trouble than it's worth.
That would probably be the major objection to any redefinition of the
meanings of the individual sequence permissions. We could possib
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> I also think there is some merit in splitting the access rights for nextval
> and setval, so that insert access grants access to nextval and update access
> grants access to setval (or perhaps both nextval and setval). That way people
> who can just i
Leave assembliesBatch out of the FROM and just put the condition in the
WHERE. Something like
UPDATE assembliesBatch
FROM assemblies
JOIN .
WHERE assembliesBatch.AssemblyID = assemblies.assemblyID
AND assembliesBatch.batchID = 5
Ian Harding
Programmer/Analyst II
Tacoma-Pierce County He
Sorry, this should have been going to performance.
Regards,
Robin
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
On Wed, 2004-10-13 at 18:01 +0200, Robin Ericsson wrote:
> Using exact timestamp makes the query go back as it should in speed (see
> explain below). However I still have the problem using a stored
> procedure or even using the "ago"-example from above.
Well, changing ago() to use timestamp withou
"Don Kelloway" <[EMAIL PROTECTED]> writes:
> I'm a first-time user with PostgreSQL so please forgive my ignorance.
>
> I've purchased (and read) Practical PostgreSQL (O'Reilly) and
> PostgreSQL Essential Reference (New Riders). So far, so good. I
> think learning PostgreSQL will not be as difficu
On Wed, Oct 13, 2004 at 00:37:35 -0600,
Michael Fuhr <[EMAIL PROTECTED]> wrote:
> Comments? Can anybody think of why cascading GRANT and REVOKE to
> implicit sequences might be A Bad Idea?
Since you can do odd things using explicit sequences, limiting implicit
sequences to make things convenien
Am Mi, den 13.10.2004 schrieb Michael Kleiser um 17:44:
> I found on
> http://www.physiol.ox.ac.uk/Computing/Online_Documentation/postgresql/plpgsql-porting.html
> that it is not poosible to use start or end a transaction in plpgsl.
>
> I tried to create a plplsql-function on PostgreSQL 8.0 beta 3
Thanks. I was thinking iirc was the transport
protocol :-)
Looks like dblink is the best bet here.
--Ted
--- Richard Huxton <[EMAIL PROTECTED]> wrote:
> Ted Shab wrote:
> > Richard,
> >
> > Thanks for the response.
> >
> > I'll look into both the dblink and iirc.
> >
> > Do you know of any
Ted Shab wrote:
Richard,
Thanks for the response.
I'll look into both the dblink and iirc.
Do you know of any extended examples of either?
dblink is in the contrib/ folder of the source distribution and possibly
your packaged version if you use such a thing. Never needed it myself,
but the doc
On Wed, Oct 13, 2004 at 08:32:04AM -0700, Ted Shab wrote:
> Thanks for the response.
>
> I'll look into both the dblink and iirc.
That's actually only dblink. IIRC is an acronym, meaning "if I recall
correctly", IIRC.
--
Alvaro Herrera ()
"The West won the world not by the superiority of it
I found on
http://www.physiol.ox.ac.uk/Computing/Online_Documentation/postgresql/plpgsql-porting.html
that it is not poosible to use start or end a transaction in plpgsl.
I tried to create a plplsql-function on PostgreSQL 8.0 beta 3
I can comile
CREATE OR REPLACE FUNCTION insert_many_commit( intege
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
>ERROR: could not access status of transaction 4244329
>DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0004": No
> existe el fichero o el directorio
What files actually appear in /usr/local/pgsql/data/pg_clog/ ?
The standard a
Richard,
Thanks for the response.
I'll look into both the dblink and iirc.
Do you know of any extended examples of either?
--Ted
--- Richard Huxton <[EMAIL PROTECTED]> wrote:
> Ted Shab wrote:
> > Hi,
> >
> > I'm trying to come up with a relatively simple
> > multi-master replication soluti
Create a file with that name filled with zeros with the same length as
the other files in that directory. That should get you far enough to
dump the data. Then run a complete set of memory and disk checks on
your system...
On Wed, Oct 13, 2004 at 02:56:37PM +0100, [EMAIL PROTECTED] wrote:
> Hi:
>
Gaetano Mendola wrote:
[EMAIL PROTECTED] wrote:
Hi:
Is there any way to recover data from a corrupted table? I can only
run SELECTs on certain WHERE conditions.
I cannot vacuum, pg_dump, I've deleted the indexes and try to reindex,
always get error:
ERROR: could not access status of transactio
[EMAIL PROTECTED] wrote:
Hi:
Is there any way to recover data from a corrupted table? I can only run
SELECTs on certain WHERE conditions.
I cannot vacuum, pg_dump, I've deleted the indexes and try to reindex,
always get error:
ERROR: could not access status of transaction 4244329
DETAIL: coul
Patrick Fiche wrote:
Hi,
When I execute a function, I would like psql to show me only RAISE
NOTICE messages but not all function calls
Indeed, I currently get some messages that I don't care about :
* PL/pgSQL function "adm_user" line 321..
* CONTEXT: SQL query "SELECT."
I
Hi,
Im looking for instructions on installing the postgresql ODBC driver on
mac osx and windows. Is there any reference for that. Any help is
apprecitaed. BTW, i need to compile it and install it wihtout using the
windows installer.
Alex
---(end of broadcast)
I have a database in sql_ascii that I need to convert to Unicode. I tried using
pg_dump -Fc .. but it fails on certain characters. like this one "è"
How can I get the data transferred?
---(end of broadcast)---
TIP 8: explain analyze is your fri
[EMAIL PROTECTED] wrote:
Hi:
I've migrated a couple of weeks ago from 7.4.2 to 7.4.5 and I am getting
this error after executing a query:
Warning: pg_exec() query failed: ERROR: could not access status of
transaction 4244329 in /home/wisconsin/www/_proc/bbdd/_c_bbdd.php on
line 160
ERROR AC
I have a large amount of data that I copy in and out of Sybase very
often. Now I also want to copy this data in and out of postgres. I
have an existing script that creates the entire database(s) from scratch
in Sybase and then uses the Sybase bulk copy tool "bcp" to copy the data
in.
I alre
Hi:
Is there any way to recover data from a corrupted table? I can only run
SELECTs on certain WHERE conditions.
I cannot vacuum, pg_dump, I've deleted the indexes and try to reindex,
always get error:
ERROR: could not access status of transaction 4244329
DETAIL: could not open file "/usr/loc
On Wed, Oct 13, 2004 at 12:37:35AM -0600, Michael Fuhr wrote:
> Comments? Can anybody think of why cascading GRANT and REVOKE to
> implicit sequences might be A Bad Idea?
In current devel sources, ALTER OWNER cascades to implicit sequences.
It may be a precedent for making GRANT and REVOKE do so
Ann wrote:
> I found the reason of this question and fixed the bug :))
>
Why then don't you share it ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I have just started exploring this product:
http://www.hyperic.net/products/manager/product-specs/postgresql-management.htm
Hope it helps.
On Wed, 2004-10-13 at 07:25, Bob Powell wrote:
> Hello everyone,
>
> I would like to know if anyone has found or developed any monitoring
> software for Post
Bob Powell wrote:
Hello everyone,
I would like to know if anyone has found or developed any monitoring
software for Postgres. I would like to be able to gather statistics
about the database.
How often certain tables get hit, whats the current status of things
etc. I couldn't find much in the li
Phil Endecott wrote:
Dear All,
Within a transaction, now() and current_timestamp are constant and give
the time that the transaction started. This is normally what you want.
But I have a case where I actually need the time that the transaction
is committed, or something similar. Is there a wa
Hello everyone,
I would like to know if anyone has found or developed any monitoring
software for Postgres. I would like to be able to gather statistics
about the database.
How often certain tables get hit, whats the current status of things
etc. I couldn't find much in the lists about this.
Hi,
I think that timeofday() should solve your issue.
Just take care that this function returns text instead of timestamp... You
will have to cast it.
Patrick
> --
-
> Patrick Fiche
> email : [EMAIL PROTECTED
Dear All,
Within a transaction, now() and current_timestamp are constant and give
the time that the transaction started. This is normally what you want.
But I have a case where I actually need the time that the transaction
is committed, or something similar. Is there a way to get it? Here is
Hi
I want to test PostgreSQL v8 native windows taht allows to create a table or
column with 128 characters !!
Where can i get it ?
Thanks U for help !!
Hondjack
- Original Message -
From: "DEHAINSALA Hondjack" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 13, 2004
Hi
I have just to install postgreSQL-7.5. in windows 2003.
and the system send me this error :
>Bad system call postmaster
Someone can help me ?
thanks U
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi:
I've migrated a couple of weeks ago from 7.4.2 to 7.4.5 and I am getting
this error after executing a query:
Warning: pg_exec() query failed: ERROR: could not access status of
transaction 4244329 in /home/wisconsin/www/_proc/bbdd/_c_bbdd.php on
line 160
ERROR ACCESO BASE DE DATOSERROR:
Hi,
When I execute a
function, I would like psql to show me only RAISE NOTICE messages but not all
function calls
Indeed, I currently
get some messages that I don't care about :
PL/pgSQL function
"adm_user" line 321..
CONTEXT: SQL query
"SELECT."
Is there a way to
Henriksen, Jonas F wrote:
Hi,
how come, if you create a user with no permissions at all, having
been granted nothing, he can still log into any database, list
available tables, create new here, and then delete them again. Seems
odd...:
Is this right, or is there something wrong with my settings in
Hi again,
On Wed, 2004-10-13 at 10:55, fx gamoy wrote:
> hello everybody,
> i ve got two big tables with the same structure.
>
> i would like to add the second one to the first one directly without
> generating a sql file. (each table is about 1 Million line)
> Is it a way with an sql command?
Hi,
On Wed, 2004-10-13 at 10:55, fx gamoy wrote:
> hello everybody,
> i ve got two big tables with the same structure.
>
> i would like to add the second one to the first one directly without
> generating a sql file. (each table is about 1 Million line)
> Is it a way with an sql command?
> INSE
hello everybody,
i ve got two big tables with the same
structure.
i would like to add the second one to the first one
directly without generating a sql file. (each table is about 1 Million
line)
Is it a way with an sql command?
INSERT INTO TAB1... (select * from TAB2)
???
thanks
fx
Hi,
how come, if you create a user with no permissions at all, having been granted
nothing, he can still log into any database, list available tables, create new here,
and then delete them again. Seems odd...:
medusa:~% createuser odd
Shall the new user be allowed to create databases? (y/n) n
Ted Shab wrote:
Hi,
I'm trying to come up with a relatively simple
multi-master replication solution. This is for
multiple databases that need to be discreet, and
change relatively infrequently (10-30 updates an
hour), and almost never update each others data (less
than once a day).
The TCL-bas
On Wed, 2004-10-13 at 17:26, postgres2008 wrote:
> and how to monitor its concurrent connection number as well as the
> current sql(s) execution. thanks!
http://www.postgresql.org/docs/7.4/static/monitoring-stats.html
-Neil
---(end of broadcast)-
hi,
could anyone tell me how to open stat log in postgres? and how to monitor its
concurrent connection number as well as the current sql(s) execution. thanks!
---
马上到http://www.126.com申请260M全国最大免费邮箱;!
提供新邮件到达手机短信提醒功能, 随时掌握邮件信息!
-
73 matches
Mail list logo
