--- Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm really not able to connect to my database server.
Does
nmap -sS localhost show that port 5432 is open and used by postgresql?
---(end of broadcast)---
TIP 9: In versions below 8.
Also,-402 sqlcode means "connection attempt to the database did not succeed"does this mean that my application is connecting to the database server but somehow failing in connecting to the database dbxyz due to some authentication problems???
~HarpreetOn 8/13/06, Harpreet Dhaliwal <
[EMAIL PROTECTE
Hello,I'm really not able to connect to my database server.
Let me explain the whole thing once again so that I don't miss telling anything.
I have a user account jsb that owns directory /usr/local/pgsql/jsb
initdb is done on the same directory i.e. /usr/local/pgsql/jsb
So all the db related fil
On 8/12/06, Jaime Casanova <[EMAIL PROTECTED]> wrote:
> well, since he wrote his app in vb.net he is probably using postgresql
> as a dumb data store, it might not be all that difficult. still, not a
> very smart move.
so if you have functions on server side or triggers or rules... then
you need
On 8/12/06, Merlin Moncure <[EMAIL PROTECTED]> wrote:
On 8/12/06, RPK <[EMAIL PROTECTED]> wrote:
>
> 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 N
well, since he wrote his app in vb.net he is probably using postgresql
as a dumb data store, it might not be all that difficult. still, not a
very smart move.
so if you have functions on server side or triggers or rules... then
you need some rewrite on the app... otherwise just to adapt the sql
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.
the database is backed up with the pg_dump utility. make a batch file
which has the line:
pg_dump my_database
and automate it with the windo
On 8/12/06, Bill Moran <[EMAIL PROTECTED]> wrote:
RPK <[EMAIL PROTECTED]> wrote:
>
> How can I migrate a PostgreSQL database to MySQL or MS Access?
in your case i would suggest ms dts or vb script in conjunction with
the odbc driver for both databases.
You can't. Neither MySQL nor Access su
On 8/12/06, RPK <[EMAIL PROTECTED]> wrote:
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?
iirc ntfs is required
RPK <[EMAIL PROTECTED]> wrote:
>
> How can I migrate a PostgreSQL database to MySQL or MS Access?
You can't. Neither MySQL nor Access support the advanced features in
PostgreSQL. You'll probably have to rewrite the app.
--
Bill Moran
Microsoft: Where do you want to go today?
Linux: Where do
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
>> PostgreSQL
>> database?
>>
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
RPK wrote:
> Are there any ready-made backup scripts available that can backup PostgreSQL
> database?
>
Have you checked out pgAdmin yet?
--
John Meyer
http://pueblonative.wordpress.com
http://pueblonative.110mb.com/board
---(end of broadcast)---
Martijn van Oosterhout writes:
> Temporary tables still get an entry in pg_class, so for truly readonly
> systems they wouldn't work.
The "READONLY" transaction status is a security mechanism, not a
performance-enhancing mechanism. It makes no pretense of preventing
all disk writes. I think a r
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.
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)--
Thomas Kellerer <[EMAIL PROTECTED]> writes:
> What do you do if a document gets deleted? Renumber the "following" documents
> so that no gaps are present in the already used ids?
There's no deletion possibility. A RULE sets a column named "active" to
"False" instead (I can set it manually or let
I am using libpqxx.. library .. i need errorcode from the connection object in the libpqxx library...
On 8/12/06, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote:
http://www.postgresql.org/docs/8.1/interactive/ecpg-errors.html#AEN27672
printf("Error code is %d",SQLCODE)
I hope this helps
"chris smith" <[EMAIL PROTECTED]> writes:
> Why does it matter?
>
> I assume there is a reason you need it like this..
Of course there is. It is a project requirement and also a law requirement
that there's no unused number and that they be chronologically ordered as
well. This is also part of
http://www.postgresql.org/docs/8.1/interactive/ecpg-errors.html#AEN27672
printf("Error code is %d",SQLCODE)
I hope this helps
On 8/12/06, Sandeep Kumar Jakkaraju <[EMAIL PROTECTED]> wrote:
Hi All I want to know specifically from the exception thrown by the "connection" object when the connnec
Jorge Godoy wrote on 12.08.2006 01:33:
I was trying to solve a problem on an old system and realized that there might
be some better approach for doing what I need.
We have some documents that need to be ordered sequentially and without gaps.
I could use a sequence, but if the transaction fails
On 8/12/06, Jorge Godoy <[EMAIL PROTECTED]> wrote:
Hi!
I was trying to solve a problem on an old system and realized that there might
be some better approach for doing what I need.
We have some documents that need to be ordered sequentially and without gaps.
I could use a sequence, but if the
David Fetter wrote:
Folks,
I'm looking for user experiences with Jasper Reports with PostgreSQL
so I can give $client the low-down on this system, especially in
comparison to Business Objects. Please let me know if you're using it
or have assessed it in some systematic way.
Well in comparison
On Sat, Aug 12, 2006 at 08:57:49AM +0200, Peter Eisentraut wrote:
> > It does seem a bit inconsistent that we allow you to write into a
> > temp table during a "READONLY" transaction, but not to create/drop
> > one. I'm not excited about changing it though, as the tests to see if
> > the command is
On Fri, Aug 11, 2006 at 11:40:53PM -0400, Harpreet Dhaliwal wrote:
> What kind of patch are you talking about?
A documentation patch. Michael Meskes, to whom I was responding,
maintains ECPG. I was asking whether he wanted me to submit a patch
to fix misleading parts of the documentation or whet
Hi All I want to know specifically from the exception thrown by the "connection" object when the connnection string is wrong..whether it is due to wrong database name or wrong user name or wrong password !!!
Is it possible ??Thanx in advance-- Sandeep Kumar Jakkaraju WeBlog:http://jakkarajus.blogsp
What kind of patch are you talking about?
On 8/11/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Fri, Aug 11, 2006 at 06:09:16PM +0200, Michael Meskes wrote:> On Fri, Aug 11, 2006 at 07:01:55AM -0600, Michael Fuhr wrote:
> > The ECPG "Connecting to the Database Server" documentation does> > have an
Tom Lane wrote:
> Richard Huxton writes:
> > Carl R. Brune wrote:
> >> I should have added that I want to make further use of the
> >> temporary table after the COMMIT -- the rollback approach you
> >> propose makes it go away.
> >
> > In which case the transaction isn't READONLY.
>
> It does seem
Mavinakuli, Prasanna (STSD) wrote:
> When we pass file name in pg_ctl (with option -l) what has to be
> syslog value..
If you turn on syslog, the -l filename won't get much output, but you
still might get error messages during startup, before syslog is
activated, so both are independently useful
29 matches
Mail list logo
