Re: [ADMIN] Tyan Thunder MB for postgres server

We use that exact configuration right now, except with an Adaptec card (Band more RAM. (B (BWe used RHEL 3.0, then switched to Fedora core 2 64Bit as a test, since (Bthis server was since placed into standby duties. Well, we needed to use (Bthe server when the main server went into maintenance

Re: [ADMIN] Time is off in PG server

Making the setting in the postgresql.conf file worked after i HUP'd the postmaster, and logged back into my psql sessions. timezone = 'EST5EDT' Thanks a million. - Ericson "set local" was probably not what you wanted to use here. Per the man page: Note that SET LOCAL will appear to have no ef

Re: [ADMIN] Time is off in PG server

Tom Lane wrote: Ericson Smith <[EMAIL PROTECTED]> writes: When using date oriented functions on Postgresql, the time is an hour off, or in certain times, one hour ahead. System Timezone: EST System Time (date command): Thu Aug 26 09:44:28 EDT 2004 SELECT now(); : 2004-08-26

[ADMIN] Time is off in PG server

-26'::timestamp) ; : 1093496400 (1am on that day -- should be 12pm) Any suggestions? -- Warmest regards, Ericson Smith Tracking Specialist/DBA +---+--+ | http://www.did-it.com | Need help tracking your paid | | [EMAIL PROTECTED]

Re: [ADMIN] Clustering Postgres

-with-tcl \ --with-readline \ --with-zlib make -j 2 CPPFLAGS="-O3 -DALLOW_ABSOLUTE_DBPATHS -DLOCK_DEBUG" all Ericson Smith wrote: Do you mean that you are actually testing this product now? If so, what's the hardware configuration (nodes, storage server, interconnects) that yo

Re: [ADMIN] Clustering Postgres

Do you mean that you are actually testing this product now? If so, what's the hardware configuration (nodes, storage server, interconnects) that you are using? Warmest regards, Ericson Smith Tracking Specialist/DBA +---+-+ |

Re: [ADMIN] Out of space

Why not just get a bigger disk? Warmest regards, Ericson Smith Tracking Specialist/DBA +---+-+ | http://www.did-it.com | "When you have to shoot, shoot, | | [EMAIL PROTECTED] | don't talk! - Tuco | | 51

Re: [ADMIN] PG 7.2.4 and waiting backends

regards, Ericson Smith Tracking Specialist/DBA +---+-+ | http://www.did-it.com | "When you have to shoot, shoot, | | [EMAIL PROTECTED] | don't talk! - Tuco | | 51

[ADMIN] Looking for Developer with Postgresql experience

proficiencies, and a desire to learn on the job. They will need interpersonal skills to work with customer service representatives and clients to diagnose and solve customer issues. This Position is On-Site and is located in Long Island (NY), 45 Minutes from NYC. Warmest regards, Ericson Smith

[ADMIN] Looking for Developer with Postgresql experience

Database, SQL skills Pluses: Internet ASP Model experience Internet Marketing skills PostgreSQL experience Basic Networking skills (TCP/IP) -- Warmest regards, Ericson Smith Tracking Specialist/DBA +---+-+ | http://www.did-it.com | "When you

Re: [ADMIN] remote access to linux

Yes, look into http://www.realvnc.com/what.html Don't forget SSH console access as well. Regards - Ericson vidhya wrote: Hi, I want to access the Linux server in US from win2k in India. Do you have any service like terminal services client to access the Linux server. Thank u, Regards,

Re: [ADMIN] How do I select the last Id in a column???

To get the ID after the fact: SELECT currval('my_seq') AS id; To get the ID before even inserting it SELECT nextval('my_seq') AS id; - Ericson Smith [EMAIL PROTECTED] Josh Goldberg wrote: to get the last record inserted just select * from row order by autoincId desc

[ADMIN] Bit string manipulation in Postgresql

not immediately find a way around this issue. Any pointers to documentation (or perhaps another way to implement this issue) would be very helpful. Regards Ericson Smith [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]