Re: [GENERAL] PostgreSQL Certification
Am Sonntag, den 12.06.2005, 14:36 +1000 schrieb CaT: > On Sun, Jun 12, 2005 at 12:24:30PM +0900, Tatsuo Ishii wrote: > > Thank you for interested in PostgreSQL CE. There is a sample > > examination problems page: > > > > http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en > > > > You could find some idea what the exam looks like. > > My mind broke parsing this question: > > Choose two options in "postgresql.conf" which the most suited values > depending on the OS status is automatically assigned at "initdb" > execution time. > > I think I maybe, almost kind-of know what it says but I am surer that my > mind is broken. > > It seems you may need an editor for your english translations (or I need > to learn to read :). For the contents too. I dont think the source code installation should be so much in the focus of the certification. I wonder how certifications in other languages and countries could work? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] PostgreSQL Certification
> For the contents too. I dont think the source code installation > should be so much in the focus of the certification. Since PostgreSQL is an open source database, I think it is important to understand how to install PostgreSQL from the source code. > I wonder how certifications in other languages and countries > could work? If there's enough demand to justify the cost for adding new language for the exam, we look forward to add new one. -- Tatsuo Ishii ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[GENERAL] CVS stability
I've been noticing some very useful things that are probably already in CVS (return_next in pl/perl, IN/OUT parameters, and probably others). I don't have a "mission critical" production environment and was wondering how unstable a typical 8.1 CVS checkout is? I'm not talking about feature-freeze, but more about uptime and compilation. Thanks, Sean ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] PostgreSQL Certification
Am Sonntag, den 12.06.2005, 17:59 +0900 schrieb Tatsuo Ishii: > > For the contents too. I dont think the source code installation > > should be so much in the focus of the certification. > > Since PostgreSQL is an open source database, I think it is important > to understand how to install PostgreSQL from the source code. Yes, but nowadays you dont learn to build a car to get a certificate to drive a car. Postgres is available on platforms (win32) for example, where you dont get in touch with the build process. (Also true for all the binary distributions, also packages on some systems where you just use make) > > > I wonder how certifications in other languages and countries > > could work? > > If there's enough demand to justify the cost for adding new language > for the exam, we look forward to add new one. Well, I was thinking of a certificate process more then just an online test. The problem seems to be to have an authoritative test center where the candidates really have something of value at their hands when they pass the certificate. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] CVS stability
Sean Davis <[EMAIL PROTECTED]> writes: > I've been noticing some very useful things that are probably already in > CVS (return_next in pl/perl, IN/OUT parameters, and probably others). > I don't have a "mission critical" production environment and was > wondering how unstable a typical 8.1 CVS checkout is? I'm not talking > about feature-freeze, but more about uptime and compilation. CVS tip is seldom actively broken; the main downside you have to be prepared for is that a snapshot will not be forwards or backwards initdb-compatible. As long as you are prepared for a full dump/restore any time you want to update, you can certainly use it for development work. You might consider grabbing one of the nightly snapshot tarballs instead of pulling directly from CVS --- less setup overhead that way (in particular you don't need any tools you wouldn't need for a regular source build). regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] Postgre "idle" process using 100% CPU
Well there should be no complex queries executed (there are some huge tables, but the queries aren't huge or specially complicated). I tried attaching to the process via gdb and the process is executing method: HeapTupleSatisfiesSnapshot() The backtrace appears to be useless (too many ??s). Is that of any help ? Regards, Jernej Kos. On Thursday 09 of June 2005 17:19, you wrote: > Jernej Kos <[EMAIL PROTECTED]> writes: > > i am using postgresql version 8.0.1 on Gentoo Linux and from time to time > > a postgres process that is marked as idle - "postgres: user db IP(34079) > > idle" - starts using 100% CPU. There is nothing in the logs, so i don't > > have a clue what could be the problem. > > For a long time? I'd expect it to go busy on receiving a command > somewhat before changing the PS status, because command parsing > happens first (else it can't know what to set the status to ...). > If you are in the habit of sending enormously complex SQL commands > then maybe this state would last long enough to notice. > > If you don't think that's it, maybe you could attach to the busy > backend with gdb and get a stack trace to find out what it's doing? > > regards, tom lane > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Jernej Kos <[EMAIL PROTECTED]> JWeb-Network ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] Postgre "idle" process using 100% CPU
Jernej Kos <[EMAIL PROTECTED]> writes: > Well there should be no complex queries executed (there are some huge tables, > but the queries aren't huge or specially complicated). I tried attaching to > the process via gdb and the process is executing method: > HeapTupleSatisfiesSnapshot() > The backtrace appears to be useless (too many ??s). Is that of any help ? It's really hard to see how it could get to HeapTupleSatisfiesSnapshot() without being inside a query --- too bad you can't get a more usable backtrace. Is it worth recompiling with --enable-debug to investigate this? regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[GENERAL] Use of Indexes
Hello, I am trying out a few databases to determine which one would best suit a project. I was wondering if someone could answer a question about how PostgreSQL uses indexes when performing queries. Particularly, I need to know if the query optimizer will use more than index for a query or if it only uses one. For instance, one of my tables (1 million records) contains a document number, a document type, a received date, a review date, an entered date, and an audited date. If I want to retrieve the following pieces of data: all of the documents of type 1 that were received yesterday all of the documents of type 2 that were entered yesterday all of the documents of type 2 that were reviewed yesterday Would I be able to create individual indexes on type, received date, entered date, and reviewed date and the optimizer would select the appropriate two indexes, or would I have to create three composite indexes that would include type-received, type-entered, and type-reviewed? Thanks for the help. Darrell ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[GENERAL] Trying to get posgreSQL-8.0.3 up on Tiger 10.4.1
Hello there, I am trying to get my PowerBook to host a postgres server. I seem to be h aving troubles with the shared-buffers. I have 1G of ram so don't know why this is a problem... Anyone else out there using pg8 on Tiger? Any advice would be appreciated... Chris ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] Fyracle?
[EMAIL PROTECTED] escreveu: Some comments: Firebird is a good small database (small resource footprint) that handles small databases with many users well. In the hospital I work we have a 4GB database with 50 users connected running 24/7 (her I stop it 2.5 hours per month) It doesn't scale well due to its single file data storage implementation. A good disk farm is mostly wasted on it. You can partitionate a database with multiple archives. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster Geraldo Lopes de Souza ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] Case sensitivity
Has case sensitivity changed between 8.0.1 and 8.0.3 or am I missing some setting somewhere? I try the following sql on two database servers and get different results: create table test (val varchar(10)); insert into test values ('A'); insert into test values ('a'); select * from test where val < 'a'; Results on 8.0.1 linux server (UNICODE) val - (0 rows) Results on 8.0.3 windows server (UNICODE) val - A (1 row) I am guessing that the 8.0.3 on windows is the correct version - but what changes this and how can I set it? regards Howard Cole www.selestial.com ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Now() function
BTW in Postgresql 8.0 you can do: ALTER TABLE foo ALTER foo_timestamp TYPE timestamp(0) with timezone; It'll do the truncation for you. Regards, Ben "Michael Glaesemann" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > On Jun 10, 2005, at 11:37 AM, Michael Glaesemann wrote: > >> A short term solution would be to update the column using something like >> update foo set foo_timestamp = date_trunc(foo_timestamp). > > Sorry. That isn't clear (or correct!) Complete example at the bottom of > the email. > > UPDATE foo > SET foo_timestamp = date_trunc('second',foo_timestamp); > > >> http://www.postgresql.org/docs/7.4/interactive/functions- >> datetime.html#FUNCTIONS-DATETIME-TRUNC > > Sorry for any confusion. > > Michael Glaesemann > grzm myrealbox com > > > test=# create table foo (foo_id serial not null unique, foo_timestamp > timestamptz not null) without oids; > NOTICE: CREATE TABLE will create implicit sequence "foo_foo_id_seq" for > serial column "foo.foo_id" > NOTICE: CREATE TABLE / UNIQUE will create implicit index > "foo_foo_id_key" for table "foo" > CREATE TABLE > test=# insert into foo (foo_timestamp) values (current_timestamp); > INSERT 0 1 > test=# insert into foo (foo_timestamp) values (current_timestamp); > INSERT 0 1 > test=# insert into foo (foo_timestamp) values (current_timestamp); > INSERT 0 1 > test=# insert into foo (foo_timestamp) values (current_timestamp); > INSERT 0 1 > test=# select * from foo; > foo_id | foo_timestamp > +--- > 1 | 2005-06-10 11:55:48.459675+09 > 2 | 2005-06-10 11:55:49.363353+09 > 3 | 2005-06-10 11:55:49.951119+09 > 4 | 2005-06-10 11:55:50.771325+09 > (4 rows) > > test=# update foo set foo_timestamp = date_trunc ('second',foo_timestamp); > UPDATE 4 > test=# select * from foo; > foo_id | foo_timestamp > + > 1 | 2005-06-10 11:55:48+09 > 2 | 2005-06-10 11:55:49+09 > 3 | 2005-06-10 11:55:49+09 > 4 | 2005-06-10 11:55:50+09 > (4 rows) > > > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] Problem in unicode sorting
We have a postgresql database in Hindi and English. The records are entered in Hindi as well as in English. The problem is in the sorting of hindi records when we give select * from table order by name the hindi sorting is not correct. For that we had intialised the initdb with en_US.UTF-8. What to do. We are writing a PHP script for inserting searching and retrieving the records. Thanx in advance with regards Madhu Aggarwal
[GENERAL] FATAL: Sorry, too many clients already????
I have a server under very light load -- just me doing some work in php. I am getting this error often and don't know why: postgresql max connections Unable to connect to PostgreSQL server: FATAL: Sorry, too many clients already my orignal postgresql.conf had: max_connections = 8 shared_buffers = 16 I changed those to 32 and 64 and it is working so far. But I have a bunch of postgresses running now with all of them doing almost nothing: postgres 11747 0.0 0.0 8612 1904 ?S00:27 0:00 postgres: stats buffer process postgres 11778 0.0 0.0 7620 1928 ?S00:27 0:00 postgres: stats collector process postgres 12950 0.0 0.0 9132 4300 ?S00:27 0:00 postgres: dcm1104_root mkim_org 127.0.0.1 idle postgres 13152 0.0 0.0 8436 3748 ?S00:27 0:00 postgres: dcm1104_root mkim_org 127.0.0.1 idle postgres 13216 0.0 0.0 8436 3644 ?S00:27 0:00 postgres: dcm1104_root mkim_org 127.0.0.1 idle postgres 13410 0.0 0.0 8036 2952 ?S00:27 0:00 postgres: dcm1104_root mkim_org 127.0.0.1 idle postgres 13474 0.0 0.0 8436 3940 ?S00:27 0:00 postgres: dcm1104_root mkim_org 127.0.0.1 idle postgres 13664 0.0 0.0 8420 3796 ?S00:27 0:00 postgres: dcm1104_root mkim_org 127.0.0.1 idle postgres 13824 0.0 0.0 8040 3024 ?S00:27 0:00 postgres: dcm1104_root mkim_org 127.0.0.1 idle postgres 13890 0.0 0.0 8436 3984 ?S00:27 0:00 postgres: dcm1104_root mkim_org 127.0.0.1 idle postgres 2466 0.0 0.0 8432 3764 ?S00:31 0:00 postgres: dcm1104_root mkim_org 127.0.0.1 idle postgres 2535 0.0 0.0 8568 3960 ?S00:31 0:00 postgres: dcm1104_root mkim_org 127.0.0.1 idle postgres 19026 0.0 0.0 8040 2940 ?S01:11 0:00 postgres: dcm1104_root mkim_org 127.0.0.1 idle i have tried both pg_connect and pg_pconnect, and this happens either way. I don't understand why it keeps starting more processes when there are others sitting around doing nothing??? Any thoughts? I am tired...Maybe I'm missing something obvious Thanks Dan ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] Trying to get posgreSQL-8.0.3 up on Tiger 10.4.1
On Tue, Jun 07, 2005 at 05:46:50PM -0700, Christopher Barbee wrote: > Hello there, > I am trying to get my PowerBook to host a postgres > server. > > > I seem to be h aving troubles with the > shared-buffers. I have 1G of ram so don't know why > this is a problem... > > Anyone else out there using pg8 on Tiger? I'm running 8.0.0 on 10.4.1 with no problems. You'll need to be much more specific about the problems you're seeing before anyone can help you, though. Cheers, Steve ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] Cannot get PostgreSQL to work with Ruby On Rails
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am having problems getting PostgreSQL to work with Ruby On Rails. On Windows, I cannot get ActiveRecord to recognize the pure ruby Postgres driver. On linux, it complains about a missing constant with the compiled postgres driver. I suspect something wrong with the database.yml file, but cannot figure out the problem. Is there anyone who has gotten this to work? Thank you. - -- Jim McMaster mailto:[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: PGP 8.1 iQA/AwUBQqYdtmaP5l7/atSJEQIT2ACg035mDpSTw5LHV/FExRJun2n9Tw8An0Bb afgJnKq076eEIDKOculhiKuz =R5Jt -END PGP SIGNATURE- ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Case sensitivity
> create table test (val varchar(10)); > insert into test values ('A'); > insert into test values ('a'); > select * from test where val < 'a'; > > Results on 8.0.1 linux server (UNICODE) > val > - > (0 rows) > > Results on 8.0.3 windows server (UNICODE) val > - > A > (1 row) > > I am guessing that the 8.0.3 on windows is the correct > version - but what changes this and how can I set it? UNICODE is not currently supported on win32. We hope to have this done in 8.1, but in 8.0 bad things like this will happen. See http://www.postgresql.org/docs/faqs.FAQ_windows.html#2.6. //Magnus ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Trying to get posgreSQL-8.0.3 up on Tiger 10.4.1
Christopher Barbee <[EMAIL PROTECTED]> writes: > I am trying to get my PowerBook to host a postgres > server. > I seem to be h aving troubles with the > shared-buffers. I have 1G of ram so don't know why > this is a problem... OS X has a pretty small default SHMMAX setting. Read the installation documentation about configuring kernel settings ... regards, tom lane ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Use of Indexes
"Darrell A. Sullivan, II" <[EMAIL PROTECTED]> writes: > I was wondering if someone could answer a question about how PostgreSQL uses > indexes when performing queries. Particularly, I need to know if the query > optimizer will use more than index for a query or if it only uses one. Versions through 8.0 can only use one index per query (per table). 8.1 will be smarter though. regards, tom lane ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Case sensitivity
Howard Cole <[EMAIL PROTECTED]> writes: > Has case sensitivity changed between 8.0.1 and 8.0.3 Nope. > Results on 8.0.3 windows server (UNICODE) Unicode doesn't work at all well on Windows. Consider using a different encoding. Also, you'd better check that you have matching locale and encoding settings on both those installations ... regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[GENERAL] mirroring oracle database in pgsql
hey all, I'm trying to convince some people here to adopt either mysql or postgresql as a relational database here.. However, we can't start from a clean slate; we have a very mature oracle database that applications point to right now, and so we need a migration path. I went to the mysql folks, and it looks like its going to be quite a while before mysql is up to the task, so I thought I'd try pgsql. Anyways, I was thinking of taking the following steps: a) finding a Java API that transparently supports both postgresql and Oracle data access and stored procedure calls. b) instrumenting the Oracle database so that all tables support timestamps on data rows. c) mirroring the Oracle database in MySQL. d) making interface code connecting the MySQL database to the Oracle database (and both applying updates to the database as well as data. In other words, I'm looking to make a postgresql -> Oracle mirroring tool, and syncing the databases on a nightly basis, and I was wondering if anybody had experience with this sort of thing. As I see it, if we pull this off we could save quite a bit in licensing costs - we'd still have oracle around, but it would only be a datastore for talking to other oracle databases, and run by batch, not accessed by end users. However: a) I'm not sure how well stored procs, views, triggers and indexes transfer over from oracle to postgresql. b) I'm not sure how scalable postgresql is, and how well it handles multiprocessor support (we'd be using a six-processor box. As an aside, how much experience do people on the list have with enterprise db? I was thinking that they might alleviate the mirroring headaches quite a bit, but they don't seem to have a solaris port.. Anybody have a take on their db? Ed ( ps - if you subscribe to the mysql list, no you're not seeing double. I posted a very similar message on the mysql lists a couple of days ago.. ) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] mirroring oracle database in pgsql
On Mon, Jun 06, 2005 at 12:52:13PM -0700, Edward Peschko wrote: > In other words, I'm looking to make a postgresql -> Oracle mirroring > tool, and syncing the databases on a nightly basis, and I was > wondering if anybody had experience with this sort of thing. You should take a look at contrib/dblink, which AFAIK allows connections from PostgreSQL to Oracle. It should make it easy to sync data between the two. > As I see it, if we pull this off we could save quite a bit in > licensing costs - we'd still have oracle around, but it > would only be a datastore for talking to other oracle databases, > and run by batch, not accessed by end users. Unless you get Oracle backups from customers or something you should probably be able to completely leave Oracle. > However: > > a) I'm not sure how well stored procs, views, triggers and >indexes transfer over from oracle to postgresql. PostgreSQL goes to great lengths to comply with ANSI SQL, probably moreso than any other database. Generally, most SQL written for Oracle that isn't using features not yet supported by PostgreSQL (such as WITH or the OLAP extensions) should play just fine. PL/PGSQL is also fairly similar to PLSQL. I think there's also some Oracle -> PostgreSQL migration tools out there. > b) I'm not sure how scalable postgresql is, and how well >it handles multiprocessor support (we'd be using a >six-processor box. It's not as scaleable as Oracle, but then again pretty much nothing else is either. It really depends on what you're doing. PostgreSQL uses a process for each connection, so an OLTP environment well make use of multiple CPUs just fine, but there's currently no support for parallel query processing so if you're doing a lot of large queries it might be an issue. > ps - if you subscribe to the mysql list, no you're not seeing double. > I posted a very similar message on the mysql lists a couple > of days ago.. Something you might want to consider is MySQL's disregard for data integrity. Try stuffing 'xx' into a varchar(1) some time and see what happens. That's just one example; http://sql-info.de/mysql/gotchas.html has a pretty complete list. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Version Control?
On Sat, Jun 11, 2005 at 02:47:39PM +0100, Russ Brown wrote: > I'd be extremely happy if somebody finds such a system that is already > written! I've never seen such a system, and one is sorely needed. If someone were to write one that worked well against multiple databases and didn't cost a fortune they could probably make a good amount of $$ with it. BTW, I believe some of the really high-end database tools will do what you're looking for, but those typically start at a couple grand or more. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Version Control?
On Sat, Jun 11, 2005 at 11:31:02AM -0500, Peter Fein wrote: > Peter Fein wrote: > > As an uninformed, off-the-wall idea, could one compare snapshots of the > > system tables to generate these diffs? I know next-to-nothing about > > these, but it seems like they'd contain the info you'd need. > > Here's another nutty idea: Could one create a (carefully designed) audit > table on the system tables themselves? You'd need to exclude irrelevant > stuff (stats or whatever) & I'd have no idea about performance impact. > > Dumping & transforming the audit would basically give you a script that > runs through all the actions done to a schema. I'm not 100% how to use > this for an update script though. I'm not sure a straight diff of > actions will work - it seems like the results may be order dependent in > some cases and you might need to infer undos. Anyway, it's interesting... If triggers were supported on system tables, then yes, you could easily create an audit record. And yes, such a record should make it easy to generate a patch file. Personally, I've always worked in such a way that development databases tend to be re-created frequently, from a set of definition files. When it's time to create patch code, I'll diff the different versions of the files and generate a patch file based on that. Of course it'd be really handy if I could load up two databases (one with the old schema, one with the new) and have some tool compare the two and generate a diff and a patch file. Of course it might not catch everything (such as droping a column and then re-adding it with the same definition), but it would work fine in 99.99% of the cases. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Postgre "idle" process using 100% CPU
Well I can't get any better backtraces (even with --enable-debug). The strange thing is that this just happens once in a while and the process doesn't stop until it is killed (or postgre is restarted). Any suggestions ? Regards, Jernej Kos. On Sunday 12 of June 2005 18:01, you wrote: > Jernej Kos <[EMAIL PROTECTED]> writes: > > Well there should be no complex queries executed (there are some huge > > tables, but the queries aren't huge or specially complicated). I tried > > attaching to the process via gdb and the process is executing method: > > > > HeapTupleSatisfiesSnapshot() > > > > The backtrace appears to be useless (too many ??s). Is that of any help ? > > It's really hard to see how it could get to HeapTupleSatisfiesSnapshot() > without being inside a query --- too bad you can't get a more usable > backtrace. Is it worth recompiling with --enable-debug to investigate > this? > > regards, tom lane -- Jernej Kos <[EMAIL PROTECTED]> JWeb-Network ---(end of broadcast)--- TIP 8: explain analyze is your friend
[GENERAL] users,groups and permissions
Hello. If we have a database with defined user groups, users and permissions on database objects, what happens when we backup database (dump) and try to install on some other server ? Does information about user groups, users and permissions migrate along with database itself or I need to configure it separately on each computer ?
[GENERAL] retrieving information about password from MS Access front-end
How could I retrieve information about actual user password, if md5 method is set in pg_hba.conf ? I want to create VBA procedure that compares value in text box with actual password to determine if it is the same. As the password is encrypted (md5) I can't read it from pg_shaddow system table. How to retrieve decrypted value from pg_shaddow? Or at least, how to transfer value from text-box (MS Access) to Postgres so that Postgres can determine whether those two values are the same ? Thanks in advance, Zlatko
Re: [GENERAL] retrieving information about password from MS
Am Sonntag, den 12.06.2005, 23:12 +0200 schrieb Zlatko Matić: > How could I retrieve information about actual user password, if md5 > method is set in pg_hba.conf ? > I want to create VBA procedure that compares value in text box with > actual password to determine if it is the same. As the password is > encrypted (md5) I can't read it from pg_shaddow system table. How to > retrieve decrypted value from pg_shaddow? Or at least, how to transfer > value from text-box (MS Access) to Postgres so that Postgres can > determine whether those two values are the same ? You cant. md5 really is a hash, not encryption (there is no decryption) You would just try to connect - postgres will tell you if the password is wrong. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] Pb with linked tables on PG8
i had the exact same thing using the same scenario but with pg 8.0.3 installed on the same win XP pro machine. The strange thing is when I closed the table and opened it again, all the fields containing #deleted then showed up with the values I actually input. So i'm thinking theres some bug in refreshing the table each time you enter a new record. From: "Ets ROLLAND" <[EMAIL PROTECTED]> Reply-To: "Ets ROLLAND" <[EMAIL PROTECTED]> To: Subject: [GENERAL] Pb with linked tables on PG8 Date: Thu, 9 Jun 2005 13:19:57 +0200 Hello ! I have an Access database using linked tables on PG 8.0.3 (on Windows 2003 server). I use pgODBC 8.00.01.01. Some tables appear like deleted ! In Access I see : Categ : Table vt_catvt_libcat #Supprimé#Supprimé #Supprimé#Supprimé #Supprimé#Supprimé #Supprimé#Supprimé #Supprimé#Supprimé #Supprimé#Supprimé #Supprimé#Supprimé #Supprimé#Supprimé (Supprmé means deleted in French) I try to delete the link and recreate it, same problem ! I try a VACUUM FULL ANALYSE on the database, same problem ! How can I solve this problem ? Why ? Many thanks for all your explainations. Regards. Luc _ Shop til you drop at XtraMSN Shopping http://shopping.xtramsn.co.nz/home/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[GENERAL]
I am using (or was planning on - now having second thoughts) postgres 8.0.3 for windows for a database paper I have to do at university. I tried installing it on linux and having it talk through samba / ODBC to MS Access on windows, but his was a bit beyond my knowledge. So I took my tutors advice and installed the windows version - on localhost / same PC as MS access. This worked ok the first time, but then i decided to reinstall to get some screenshots, and i got this message: "Internal account lookup failure: No mappiong between account names and security IDs was done." I tried installing it freshly on a few different computers and I always get the same result. Any Ideas what this means and how to fix it? Thanks, Jeremy _ Need more speed? Get Xtra Broadband @ http://jetstream.xtra.co.nz/chm/0,,202853-1000,00.html ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] Postgres 8.1
Hi Has a roadmap and timescale been released for Postgres 8.1? All the best Simon Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599
Re: [GENERAL] [HACKERS] mirroring oracle database in pgsql
Check out EnterprisDB: www.enterprisedb.com Chris Edward Peschko wrote: hey all, I'm trying to convince some people here to adopt either mysql or postgresql as a relational database here.. However, we can't start from a clean slate; we have a very mature oracle database that applications point to right now, and so we need a migration path. I went to the mysql folks, and it looks like its going to be quite a while before mysql is up to the task, so I thought I'd try pgsql. Anyways, I was thinking of taking the following steps: a) finding a Java API that transparently supports both postgresql and Oracle data access and stored procedure calls. b) instrumenting the Oracle database so that all tables support timestamps on data rows. c) mirroring the Oracle database in MySQL. d) making interface code connecting the MySQL database to the Oracle database (and both applying updates to the database as well as data. In other words, I'm looking to make a postgresql -> Oracle mirroring tool, and syncing the databases on a nightly basis, and I was wondering if anybody had experience with this sort of thing. As I see it, if we pull this off we could save quite a bit in licensing costs - we'd still have oracle around, but it would only be a datastore for talking to other oracle databases, and run by batch, not accessed by end users. However: a) I'm not sure how well stored procs, views, triggers and indexes transfer over from oracle to postgresql. b) I'm not sure how scalable postgresql is, and how well it handles multiprocessor support (we'd be using a six-processor box. As an aside, how much experience do people on the list have with enterprise db? I was thinking that they might alleviate the mirroring headaches quite a bit, but they don't seem to have a solaris port.. Anybody have a take on their db? Ed ( ps - if you subscribe to the mysql list, no you're not seeing double. I posted a very similar message on the mysql lists a couple of days ago.. ) ---(end of broadcast)--- TIP 8: explain analyze is your friend ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] PostgreSQL Certification
> Am Sonntag, den 12.06.2005, 17:59 +0900 schrieb Tatsuo Ishii: > > > For the contents too. I dont think the source code installation > > > should be so much in the focus of the certification. > > > > Since PostgreSQL is an open source database, I think it is important > > to understand how to install PostgreSQL from the source code. > > Yes, but nowadays you dont learn to build a car to get a certificate > to drive a car. Postgres is available on platforms (win32) for example, > where you dont get in touch with the build process. > (Also true for all the binary distributions, also packages > on some systems where you just use make) Well, for me it seems your analogy is more appropriate comparing building a car with patching or hacking PostgreSQL source code:-) > > > I wonder how certifications in other languages and countries > > > could work? > > > > If there's enough demand to justify the cost for adding new language > > for the exam, we look forward to add new one. > > Well, I was thinking of a certificate process more then just an > online test. The problem seems to be to have an authoritative > test center where the candidates really have something of value > at their hands when they pass the certificate. Sorry, my English ability is poor enough not to understand what you are worring about. Could you please explain more? -- Tatsuo Ishii ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Postgres 8.1
On Sun, Jun 12, 2005 at 23:03:35 +0100, Simon Windsor <[EMAIL PROTECTED]> wrote: > > Has a roadmap and timescale been released for Postgres 8.1? Feature freeze will be July 1. Expect a beta about 1 month after that (based on past experience). The date of the release is highly variable, but will probably be around December. The TODO list has information on some things that have already been done. Other things are going on, but aren't written up anywhere. Reading through the hackers archives should give you some more information. Was there some particular feature you were interested in? ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] [INTERFACES] retrieving information about password from MS Access front-end
Hi, On 6/13/05, Zlatko Matić <[EMAIL PROTECTED]> wrote: > I want to create VBA procedure that compares value in text box with actual > password to determine if it is the same. As the password is encrypted (md5) > I can't read it from pg_shaddow system table. How to retrieve decrypted > value from pg_shaddow? It's (practically) impossible to decrypt a MD5 hashed password. > Or at least, how to transfer value from text-box (MS Access) to Postgres > so that Postgres can determine whether those two values > are the same ? You need to MD5 hash the input passsword and compare hashed input password with the one in pg_shadow. For instance: -- $1 for password input. SELECT usernm FROM recs WHERE passwd = md5($1) Furthermore, it'll bring some potential security problems to be able to access pg_shadow which requires db admin permissions. Regards. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]