[ADMIN] Data Transfer from Postgresql to Sybase

2002-11-15 Thread Karthick V
  Hi   I have a database in PostgreSQL. I need to transfer all the data from it to a sybase server located remotely. How do I do it. Is there any tool like DTS(MSSQL Server) to transfer the data.   Both my systems are on Linux and basically this functionality is a part of a larger database

Re: [ADMIN] VACUUM

2002-11-15 Thread Jodi Kanter
Do you have a URL for that document you mention? I get nothing when I search on pgsql-general. Thanks for the help. Jodi - Original Message - From: "Robert Treat" <[EMAIL PROTECTED]> To: "Jodi Kanter" <[EMAIL PROTECTED]> Cc: "Postgres Admin List" <[EMAIL PROTECTED]> Sent: Thursday, Novembe

Re: [ADMIN] VACUUM

2002-11-15 Thread Robert Treat
http://groups.google.com/groups?q=tom+lane+index+group:comp.databases.postgresql.general&hl=en&lr=&ie=UTF-8&selm=23812.1037210966%40sss.pgh.pa.us&rnum=6 hows that for a URL? Robert Treat On Fri, 2002-11-15 at 08:27, Jodi Kanter wrote: > Do you have a URL for that document you mention? I get noth

[ADMIN] table locking?

2002-11-15 Thread Jodi Kanter
If a Vacuum Full is done in the midst of a user transaction what happens to the transaction? Will it complete once the vacuum full releases the tables? Thanks Jodi ___Jodi L KanterBioInformatics Database AdministratorUniversity of Virginia(434) 924-2846[EMAIL P

[ADMIN] Missing data frrom a shutdown

2002-11-15 Thread Jorge Sauma
Hi, Yesterday we suffered a power cut in our office, so the postgresql server dies (the UPS didn't function properly). When the power was restablished the service started Ok, but we realize we have lost the records from the last hour. We hope this records are in the logs (pg_xlog or pg_clog)

[ADMIN] More one BDD

2002-11-15 Thread Andrés Ruz Salinas
Hi friends, y need help con postgres in the following. This execute a query in two bdd for not to be how to make it. The main idea is ¿what is the instruction or function with which I have connect two BDD and get a only result?. Sorry for my English, I native language is Spanish. Thanks a l

[ADMIN] query

2002-11-15 Thread Jodi Kanter
I have a query that pulls two fields across three tables such that the results are in two columns:   layout.probe    spot.signal value1        some value value2    some value value3    some value value1    some value value2    so

[ADMIN] PostgreSQL and file system level backup

2002-11-15 Thread Murthy Kambhampaty
The postgresql documentation states that in order to get a usable backup from a filesystem dump (or copy) the database server must be shut down. Moreover, "Half-way measures such as disallowing all connections will not work as there is always some buffering going on. For this reason it is also not

Re: [ADMIN] Missing data frrom a shutdown

2002-11-15 Thread Bruce Momjian
This is very unusual. Were you running with fsync off? I can't imagine what would cause this. What version are you running. As a guess, try dropping and recreating the index on the table and see if the data reappears. -