[GENERAL] MVCC cons

I want to know whether MVCC has cons also. Is it heavy on resources? How PGSQL MVCC relates with SQL Server 2005 new Snapshot Isolation. -- View this message in context: http://www.nabble.com/MVCC-cons-tf4268841.html#a12149505 Sent from the PostgreSQL - general mailing list archive at Nabble.com

[GENERAL] Tablespace

When PGSQL is installed, it creates two default tablespaces, postgres and pg_default. When a user creates a new database he is opted to select a tablespace from the above two. Do I need to create a different tablespace before creating a database in order to prevent playing with these default table

Re: [GENERAL] WAL Queries

How to change the path of WAL? How much free space to leave on hard disk for effective performance? Since it is disabled by default, is it insignificant to ENABLE it? >You need to restart PostgreSQL after the file has been modified - it >does not need to be shut down whilst the modification is

Re: [GENERAL] WAL Queries

Before modifying postgresql.conf, do I need to stop PGSQL service? >Enable it in the "Write Ahead Log" section of postgresql.conf file in >the PGDATA directory. -- View this message in context: http://www.nabble.com/WAL-Queries-tf4218911.html#a12003653 Sent from the PostgreSQL - general mail

[GENERAL] PGSQL internals

I am a beginner. I want to read the actual working of PGSQL right from the start when it is installed. What it does in the background when a new database is created, insert are issued and when the records are finally committed. I want to read the actual internal working sequentially. Where can I f

[GENERAL] WAL Queries

I installed PGSQL on Windows XP. I ran: Select pg_start_backup('label'); It responded: "Archive disabled" Is WAL archiving disabled by default? Can this feature be enabled while installing PGSQL? Can I change the path of the logs to another partition on my hard disk? -- View this message in c

[GENERAL] Store dates in database in different format

I am using pgsql 8.2.3 on windows XP. I noticed that dates are store in 'Date' columns of a table in "-mm-dd" format whereas I want to store it in "dd-MMM-" format. Can I change this? -- View this message in context: http://www.nabble.com/Store-dates-in-database-in-different-format-tf365

Re: [GENERAL] Modify existing index

How to see the details of indexes being used by a table? If I want to drop an index, how can I do that? >The choice of what your primary key is should arise from the schema >design, not the frequency of queries. If you are querying columns >other than the primary key, just add another index.

Re: [GENERAL] Schema relationship diagram

>quote author='Andreas Kretschmer-2'> > Depends on your distribition I am using pgsql 8.2.3 on Windows XP. I think open source programs are all better out for Debian like thing. They work horribly strange on Windows. -- View this message in context: http://www.nabble.com/Schema-relationship-dia

[GENERAL] Modify existing index

I have a table and a column that is primary key. I want to modify the existing index and use two other columns to be used for indexing. Since queries will be run using these two columns, hence I want to use them. Can I modify the existing index using pgAdmin? Which type of index will suit this ta

Re: [GENERAL] Schema relationship diagram

Where I can find this? am Fri, dem 20.04.2007, um 9:22:21 -0700 mailte RPK folgendes: > Is there any feature in PGSQL to view the schema relationship diagram? You can use tools like postgresql-autodoc for this. -- View this message in context: http://www.nabble.com/Schema-relations

[GENERAL] Schema relationship diagram

Is there any feature in PGSQL to view the schema relationship diagram? -- View this message in context: http://www.nabble.com/Schema-relationship-diagram-tf3619278.html#a10105662 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---(end of broadcast

[GENERAL] Documenting PGSQL database.

I am using PGSQL 8.2.3 on Windows XP. I want to know whether there is any way of documenting the schema of PGSQL database so that I can get a printed copy of the same. -- View this message in context: http://www.nabble.com/Documenting-PGSQL-database.-tf3541712.html#a9886934 Sent from the Postgre

[GENERAL] Wrong increments of Sequence

I have created a sequence with minimum value=1 and increment=1. But whenever I enter a record in a table and use nextval('seqstudentmaster') to insert new studentid, it is incremented by 20. How to set it to increment by 1? -- View this message in context: http://www.nabble.com/Wrong-increments-

[GENERAL] Connecting a sequence with table column

I am using PGSQL 8.2.3 on Windows XP and pgAdmin 1.6.3. While adding columns to a table from pgAdmin front-end, an option appears "sequence" with a drop-down box on the column creation window, but it remains disabled. I have already created a sequence but want to connect that sequence with this co

[GENERAL] Determine users and roles

I want to determine the usernames, privileges and roles of the users that are created for a particular database. I am using PGSQL 8.2.3 on Windows XP. I want to run SQL query for this. -- View this message in context: http://www.nabble.com/Determine-users-and-roles-tf3360480.html#a9347822 Sent f

Re: [GENERAL] Composite Keys

Alvaro, I am using VB.NET. How to enable locking from within VB.NET for PostgreSQL? Which command need to be executed? Alvaro Herrera-7 wrote: > >>Lock the table beforehand. Only one user can be getting the >>max(ReceiptNo) that way. > >>Alternatively, you could use userlocks, so that you c

Re: [GENERAL] Composite Keys

Jorge, For other tables I have ID field which is incremented by sequence. But for this table, there is not ID field. Receipt No will be incremented by finding the max value from the existing Receipt Nos. corresponding to that Book No. This case has a drawback as compared to the sequences in other

Re: [GENERAL] problem installing NPGSQL and pgOLEDB with .NET

I am using NPGSQL but noticed degraded performance when only 5 to 10 records are there. ODBC was very fast. -- View this message in context: http://www.nabble.com/problem-installing-NPGSQL-and-pgOLEDB-with-.NET-tf3282768.html#a9156510 Sent from the PostgreSQL - general mailing list archive at N

Re: [GENERAL] Inserting a new column in between.

Andreas, I am talking about inserting a field or changing their order in the structure itself. In MS Access and SQL Server we have this facility. Some times I need to shift the less important field to the last so that when I query using: Select * from tablename; the un-necessary field gets disp

Re: [GENERAL] Inserting a new column in between.

I think pgsql front-end needs this facility in future. Joshua D. Drake wrote: > > RPK wrote: >> I want to know whether I can insert a new column in between in an >> existing >> table. My table has 10 fields and I want to insert a field after third >> field. &

Re: [GENERAL] problem installing NPGSQL and pgOLEDB with .NET

Magnus, NPGSQL worked on one of our systems. You are right that I need to include both the dlls in the reference. I want to know more about NPGSQL and its performance benefits over pgOLEDB and ODBC.NET drivers. It's doc. does not contain much info. Magnus Hagander-2 wrote: > >

[GENERAL] Inserting a new column in between.

I want to know whether I can insert a new column in between in an existing table. My table has 10 fields and I want to insert a field after third field. -- View this message in context: http://www.nabble.com/Inserting-a-new-column-in-between.-tf3286148.html#a9140871 Sent from the PostgreSQL - ge

Re: [GENERAL] Installing PGSQL Client

I installed PGSQL on both machines. Then I opened pgAdmin and from the left pane tried to add the server. But it is not connecting. A window gets open saying all things about listner. I even passed the server's IP Address but still not working. Joshua D. Drake wrote: > > RPK wrote:

[GENERAL] problem installing NPGSQL and pgOLEDB with .NET

I have PostgreSQL 8.2 installed on Windows XP. I installed NPGSQL driver for .NET and tried to register it's dll with following command: regsvr32 c:\windows\system32\npgsql.dll It displays error: "Could not be registered, entry point not found". I copied the NPGSQL driver files in application f

[GENERAL] Composite Keys

First, can a primary key field be only one? I mean can I define a primary containing two fields. I have a table called "Payments" where there are two fields, "ReceiptNo" and "PaymentDate". If I take "ReceiptNo" only as a primary key then chances are of "primary key violation". Because in some pl

Re: [GENERAL] Installing PGSQL Client

Windows XP Richard Huxton wrote: > > RPK wrote: >> I have installed PGSQL on server. How to install PGSQL client to connect >> to >> the PGSQL database server. > > You've installed on what? Windows? Solaris? FreeBSD? RedHat Enterprise?... > >

[GENERAL] PGSQL Locking vs. Oracle's MVCC

How is PGSQL Locking compared with Oracle's MVCC? How PGSQL handles concurreny and how it differs with Oracle's Multi-Version Concurrency Control (MVCC)? -- View this message in context: http://www.nabble.com/PGSQL-Locking-vs.-Oracle%27s-MVCC-tf3277425.html#a9114584 Sent from the PostgreSQL - ge

[GENERAL] Installing PGSQL Client

I have installed PGSQL on server. How to install PGSQL client to connect to the PGSQL database server. -- View this message in context: http://www.nabble.com/Installing-PGSQL-Client-tf3277417.html#a9114562 Sent from the PostgreSQL - general mailing list archive at Nabble.com. -

[GENERAL] Encryption/Decryption in PGSQL

Is there any built in function in PGSQL to Encrypt/Decrypt a text before storing in field? If yes, which algorithms it supports and what is the maximum key size? -- View this message in context: http://www.nabble.com/Encryption-Decryption-in-PGSQL-tf3247467.html#a9027615 Sent from the PostgreSQL

Re: [GENERAL] Option to undo last update on table.

In my case, I did an accidental update on a large table where different column values have changed. I continued working and found next day that something wrong happened. Rollback will just rollback to last step (if I am right), but is there a way to bring the table to a certain TimeStamp. Just i

[GENERAL] Option to undo last update on table.

Is there any option in PGSQL to undo last changes done on a table? Any feature similar to "FlashBack Query" in Oracle. -- View this message in context: http://www.nabble.com/Option-to-undo-last-update-on-table.-tf3232456.html#a8981518 Sent from the PostgreSQL - general mailing list archive at N

Re: [GENERAL] PGSQL 8.2.3 Installation problem

to me. >> Any body install win32 version with success??? >> >> best regards >> MDC >> >> >> --- RPK <[EMAIL PROTECTED]> escribió: >> >>> When I run the setup of PGSQL 8.2.3, it displays >>> error while initializ

[GENERAL] PGSQL 8.2.3 Installation problem

When I run the setup of PGSQL 8.2.3, it displays error while initializing database cluster. Error displayed is: "Failed to execute initdb. Unable to set file system permissions". I am installing on Windows XP SP2 with "administrator" log in. -- View this message in context: http://www.nabble.co

[GENERAL] PGSQL backup options

We are planning a mission-critical client/server application and want to use PGSQL as backend to VB.NET. Before designing I want to test all the backup and recovery options available in PGSQL and also options with which we can recover from PGSQL service failure. Where I can find all the back/reco

[GENERAL] PostgreSQL/FireBird

How is FireBird rated when compared with PostgreSQL? -- View this message in context: http://www.nabble.com/PostgreSQL-FireBird-tf3158857.html#a8761237 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---(end of broadcast)-

[GENERAL] PGSQL backup types and scheduling.

I want to know how many types of backup/restore options are in PGSQL. I use VB.NET as front-end and want to schedule backup on time-basis from within VB.NET. How can it be done? Please suggest any link for more on Backups. -- View this message in context: http://www.nabble.com/PGSQL-backup-type

[GENERAL] Performing backup from VB.NET

I want to perform database backup (pgdump) from within VB.NET. Can it be done? -- View this message in context: http://www.nabble.com/Performing-backup-from-VB.NET-tf2821997.html#a7876541 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---(end of

Re: [GENERAL] Automatic Backup Script

John, I am using pgAdminIII 1.4.6. But I want to automate the backup procedure from within my VB.NET 2003 application. I want to run the script after n minutes. John Meyer wrote: > > RPK wrote: >> Are there any ready-made backup scripts available that can backup >> Post

[GENERAL] Deploying app. using PostgreSQL

I developed an app. using VB.NET 2003 and PostgreSQL 8.1.3. I want to deploy this app. at customer site. It is not sure that they are having an NTFS partition or not. Do we need to create an NTFS partition to install PostgreSQL? I also want to know whether there is a separate PostgreSQL client ve

[GENERAL] Migrating PostgreSQL database to MySQL/MS Access

How can I migrate a PostgreSQL database to MySQL or MS Access? Are there any tools available? -- View this message in context: http://www.nabble.com/Migrating-PostgreSQL-database-to-MySQL-MS-Access-tf2095559.html#a5776442 Sent from the PostgreSQL - general forum at Nabble.com.

[GENERAL] Automatic Backup Script

Are there any ready-made backup scripts available that can backup PostgreSQL database? -- View this message in context: http://www.nabble.com/Automatic-Backup-Script-tf2095554.html#a5776431 Sent from the PostgreSQL - general forum at Nabble.com. ---(end of broadcast)--

Re: [GENERAL] Restoring database from old DATA folder

>Was the old postgres stopped when you created the copy? >Was the new postgres stopped when you put the copy in? >Did you restore correct permissions when you put the copy in? >Is the new install the same version of postgres as the old one? >What are the error messages? I t

[GENERAL] Restoring database from old DATA folder

I have a DATA folder of my previous PostgreSQL 8.1 (Windows XP) installation. I do not have any DUMP or other backups. I want to use this folder instead of the newly created DATA folder after new installtion. I tried replacing the new folder with the old folder, but it did not work. pgAdmin also

[GENERAL] Installing and using SLONY-I cluster

I am using PostgreSQL 8.1 and pgAdmin III 1.4.6 on Windows XP. When I try to create a new SLONY-I cluster from pgAdmin -> Replication, it displays a message below on the dialog box, "SLONY-I scripts not installed". Please let me know from where to install these scripts and how to use clustering f

[GENERAL] Scheduling Automatic Backups

I want to Schedule Automatic Backups of PostgreSQL, either using any Front-end or from within VB.NET 2003, so that there is no chance of highly critical data of my customer. How it can be done? -- View this message in context: http://www.nabble.com/Scheduling-Automatic-Backups-tf2052562.html#a5