masterblaster

i think after mo i-dump ang data.. tsaka ka mag-truncate ng tables..

para li-liit yung db mo..

Great idea. SQL command TRUNCATE helps when you don't want to rebuild table definitions.

hi people!!

anyone familiar with the posgresql in linux?

we have a server kasi that runs on a linux platform..me database kasi dun na everyday e nag c-create sya ng mga tables lets just say for the data of a point of sale system.

is there other way na ma bawasan ang space nya para bang archiving..kasi im using pgdump and vacuum command on the console,

tnx..

What is wrong with pg_dump that you can't do what you are asking? Just want to understand the difficulty.

If you want to cleanup, you can execute SQL scripts after a backup.

To delete delete rows from a table, it is simply a SQL script in the form

DELETE FROM <TABLE NAME> WHERE <CONDITIONAL(S)>

To delete a table

DROP TABLE <TABLE NAME>

Ano kaya maganda sa dalawa? any info? I know many are using Windows but those who run servers sometimes use Linux. What's the difference?

<{POST_SNAPBACK}>

Linux gives you a lot of freedom for implementing solid information technology solutions previously synonymous only to commercial software. For little money or no money at all, you can have access to compiler, application servers, database, browser, publishing, graphics and imaging solutions using Linux. Also with Linux, it gives you the "best of breed" or "cutting edge" solutions without the wait. Here's one example. To deploy a 64-bit application server with a database in Windows with 25 users, you need at least $5,000 to deploy in one machine. To deploy a 64-bit application server with a database in Linux with unlimited users, you need $50 (support cost) for unlimited number of machines. With the explosion of open source solutions mostly in the Linux OS, you should have no problem finding an open source solution that will meet your needs. Most of major IT companies in the US utilizes Linux to operate their business, for example, Yahoo and Google.

fedora is a commercial release right? where didja buy it and for how much? i hear its more user friendly than other linux releases.

<{POST_SNAPBACK}>

Fedora is free.

Linux Security is all really a state of mind. Back then, there werent a lot of security issues with it because not a lot of people have really been using it. A lot have been using it for Servers, but not for Desktops. But now that there are... the hackers have more reasons to write intrusive programs so we see these starting to come out of the woodworks.

 

If you really think about it, Linux would be the most vulnerable to attacks since the source code of the kernel is available to anyone and there's no need to reverse engineer any of the OS modules to figure out how it works.. except of course for the commercial releases like RedHat, etc. So I guess it really boils down to the fact that we know that at least for the most of these technical hackers, we know that they are obviously more sympathetic to the open source movement, than they are to the Evil Empire.

 

As far as market share is concerned, Linux still remains to occupy the server niche more than the desktop users and I don't really see it tipping to the other end in the near future.

<{POST_SNAPBACK}>

NASA, CIA and NSA uses Linux for security work. Windows started as desktop solution with little concern for security. It has only been lately that Microsoft has been patching security holes because of industry complaints. Linux was designed with security in mind from the beginning. An excellent tool in the wrong hands is definitely useless. I very much doubt that peaking on the source code of the Linux kernel can open it to hacking.

guys meron bang equivalent ang visual basic/visual studio sa linux?

<{POST_SNAPBACK}>

Eclipse. Doesn't support VB but supports Java and C/C++.

Before i used to repair my car except overhauling. Now, no time to thinker just visual inspection and feel of the car if something wrong then i drive it to service shop.

<{POST_SNAPBACK}>

It still pays to know something about your car. Here in the US the standard service fee for BMW labor is about $120 an hour excluding parts. I don't know if that is an issue there in the Philippines.

'98 BMW 740IL

Did lots of stuff on my car.

- change oil

- change oil filter

- change air filter

- change battery

- change brake pads

- change water pump and air-conditioning belts

- replace belt tensioner

- replace head, tail and fog lights

- change high-pressure steering lines

- replace water pump

- change oil pump

- change oil pan

- change fuse

- change radiator lines and expansion tank

- check engine using OBD interface and computer

I am not pro but I try to learn from a lot of auto sites like bimmerboard.com and also auto repair publications.

eow..tanong kow lang po about sa radiator..eh advisable ba na tubig lang ang ilagay sa radiator reserve tank or kailangan talaga ng coolant..kasi yung reserve tank ng radiator eh medyo mababa na...hmmm...can you all please help me naman what to do...what i mean is pwde ba tubig nalang or kailangan na may coolant na ilagay..what type of coolant ba...different models ba needs different coolant...what if di ko alam kung what brand yung nilagay nila before...pwede ko ba haluan ito ng ibang brand....saka tuwing kailan dapat ipalinis yung radiator nio...? sorry for my ignorance...pls do help...give me some advise and tips on maintaining my radiator...im using honda city model 2000..type z..lxi..thnks..

<{POST_SNAPBACK}>

Pwede tubig pero dapat "distilled" dahil may mineral content ang tap water. Yung mineral content ng tubig pwedeng bumara sa mga piping ng radiator at pwede ring umapekto sa thermostat. Kailangan mo pa din ng coolant dahil may anti-corrosion formula iyon na pipigil sa corrosion sa aluminum. 50/50 ang halo noon - 50% distilled water at 50% coolant. Okey lang ang halo-halo na coolant siguraduhin mo lang na pare-pareho ang main ingredients. Advisable ang radiator flush (chemical process ito) every 60,000 miles (translate mo na lang sa kilometers) pati depende na din sa manufacturers advise.

just the other day, my bro in law bought home his gf's pc ...

 

the problem seems to be that the pc doesnt recognize the keyboard ...

 

sa bootup pa lang nandun na yung "keyboard not present" err message ...

 

kinabit ko yung keyboard na yon sa pc ko ... na detect naman ...

 

i tried yung keyboard ko dun sa 2nd pc (dala ni bayaw) ... tinanggap naman !!!

 

lekat ... sumakit ulo ko ... bakit ayaw nyang tanggapin yung isang keyboard ? any ideas ?

 

salamat in adbans

<{POST_SNAPBACK}>

Subukan mo muna ikabit ang keyboard sa 2nd PC mo doon sa PC na tingin mo na may sira. Kapag sira pa din, malamang may IRQ conflict issue ang PC. "Swap" o ilipat mo ang ilang PCI cards ng computer hanggang mawala ang IRQ conflict. Pero kung gusto mo pa ng mas advanced na solusyon basahin mo na lang ito http://www.helpwithpcs.com/upgrading/change-irq-settings.htm

anybody here who can provide a link/tip to enabling/disabling telnet and remote admin in suse?

 

tnx

<{POST_SNAPBACK}>

In Suse, telnetd is disabled by default. Just in case, here are the instructions if it is enabled.

Disabling telnet for Unix systems running inetd

==============================

To disable telnetd, edit /etc/inetd.conf and comment out the telnetd entry and then refresh inetd. In /etc/inetd.conf there is a line like

telnet stream tcp nowait root /usr/sbin/tcpd in.telnetd

which can be found by search the string telnet. Comment it out by putting the pound character ("#") at the beginning of the line so that the entry looks like

#telnet stream tcp nowait root /usr/sbin/tcpd in.telnetd

Save the file and then send the UP signal to inetd. This can usually be done with the commands

cd /etc/rc.d/init.d

./inet reload

If your inet rc script does not support "reload", or you cannot find an equivalent file in the /etc/rc* directory, then find the process id using

ps auxw | grep inetd | grep -v grep

and send the process the HUP signal using

k*ll -HUP PID

where "PID" in the above is replaced by the actual process ID for inetd (the number returned in the second field of the "ps" command issued above).

dudes possible ba to block a site sa internet using just windows? if pwede po.. how do I do it? sa windows 2000 and sa windows xp.  may gusto kasi ako i block na site dito sa office eh, yung mga tao ko chat ng chat hindi na nag wowork. thanks!

<{POST_SNAPBACK}>

Replace your router with another router with a built-in firewall capability. This will allow you to block certain sites and certain ports. This is the easiest solution. Software solutions are relatively expensive.

dudes, anong program pwede ko gamitin para limited access lang yung user when he uses the computer.  like for example yung sa mga internet cafe's ang pwede nila ma access is yun games lang.  pero prohibited sila to see yung folder ng volume c, etc.. thanks! btw, it's for windows xp and 2000.

 

thanks!

<{POST_SNAPBACK}>

Configure mo yung computer mo with one Admin type user account and one or more General type user accounts. All installs should be done on the Admin type user account. Tapos set mo yung read-write access properties ng mga files at directories gamit ang Admin type user account. All users should login using the General type user account. A General user type account will end up having update permission to the My Document folder and to whatever permissions the Admin type user had given to the General type user account.

Just a small correction.

The truth is Americans will outsource everything. As long as American companies can justify RISK with their DOLLARS, they will outsource. That is the keyword - RISK.

...

 

For me its a way of thinking more than cost efficient strategies.  Mababa labor here why?  If they employ Americans as CC agents sa tingin mo ba papayag sila sa same rates ng mga Agents here sa pinas?  NO!  So why??  So bottomline bakit mataas labor cost there?  WAY OF THINKING bro!

 

...

 

<{POST_SNAPBACK}>

That is confusing logic. Here's my perspective.

I live here in the US and familiar with the CC business. Companies here outsource their call center areas primarily to cut costs. The thinking here is that CC functions in an organization is relatively low risk to outsource simply because it considered "non-revenue generating". This has already become a trend here and CEOs are quick to justify to their boards that it proven business strategy and everybody successful company is doing it; so, why not do it too?! And, that is only the first-wave of the outsourcing phenomenon sweeping the US. The second wave is already occuring where management, technical expertise and engineering, all high value functions, are being outsourced. Thus, this is no "master-slave" kind of relationship anymore. Mind you, US workers are no different than Filipinos in terms of what type of jobs they will take - both will take a janitorial job or a CEO job in a company!

The truth is Americans will outsource everything. As long as American companies can just the RISK with their DOLLARS, they will outsource. That is the keyword - RISK.

any gym workout program for weight loss ???? how many sets of this and that ? thanks...

<{POST_SNAPBACK}>

I'm not superfit by any means. But this is what helped me a lot.

Weight loss involves a combination of exercise and diet. 20-30 minutes a day of cardiovascular exercise should be enough to do the job. Try to limit your diet to 2,000 calories or less a day. It should also be a balanced diet. Try to eat less at night since your body does not require extra energy during rest time. If you want to accelerate weight loss, you can use weights. Try to find the book 'Body For Life'. It's the only book you'll ever need.

Here's a pic of my ride. Manila will tax me to death in order for me to bring it back home.

Santa Monica Boulevard street scene

Darling Harbour in Sydney, Australia

Port of Philadelphia in Philadelphia, Pennsylvannia

Disneyland store setup in California

Chinese Mann Theatre in Hollywood, California

Rica Paraleja in Dallas Texas

Santa Monica street dancing