Maybe this will help.
http://www.postgresql.org/docs/7.4/static/datatype-datetime.html
On Tue, 2004-05-18 at 09:17, Hemapriya wrote:
> Hi,
>
> Does anyone know how to set timestamp values in
> postgres.
>
> Thanks in Advance.
>
> - Priya
>
>
>
>
> _
Your ip address range is probably different when connecting via a VPN rather than in
the office. By default postgres will not allow connections from other locations even
if tcpip_socket is true without specifying an ip address range, database etc.
Checkout the docs. There is a section on pg_hb
IP address that was specified by my VPN
> connection. I read through the docs and found nothing about anything
> special with VPN connections.
>
> Regards,
> - Lily Anne
>
> -Original Message-
> From: Mike G [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 24, 2004
Hello,
I believe I found my problem. The Cisco VPN client I use encrypts data
at a 168 bit level. Postgres only supports up to 128 bit correct?
Mike
On Tue, 2004-05-25 at 23:12, mike g wrote:
> Hmm
>
> Looks like I am still in the same boat you are.
>
> I still cannot
Hello,
I finally got it to work and as some have mentioned it was not the
encryption level.
I had setup my pg_hba.conf originally like this:
host all all 10.15.0.0 255.255.255.0 trust
I was under the impression that the .0 was supposed to be equivalent to
a wildcard entry so
Thank you to all who replied with the additional info.
On Thu, May 27, 2004 at 09:35:06AM -0400, Tom Lane wrote:
> "C. Bensend" <[EMAIL PROTECTED]> writes:
> >> I had setup my pg_hba.conf originally like this:
> >> host all all 10.15.0.0 255.255.255.0 trust
> >>
> >> I was under
Hi,
I believe a fast shutdown prevents new connections to the db, sends
termination signals to any applications with current connections, and
then after it receives confirmation that those applications have aborted
their transactions and closed their connections the db stops.
It sounds like your
Do you know how it was originally installed? RPM or compiled source?
Are you also transferring data from 7.3 to 7.4?
Mike
>
> RPM can be
> On Sun, 2004-06-20 at 21:50, Adam Smith wrote:
> > I have posted this and similar questions repeatedly and can't even raise
> > a single response. I am be
What version of postgres did you install? If it is 7.4.2 or later then
you must install the cygserver package and start that. ipc-daemon2 is
not being used anymore.
Mike
On Wed, 2004-06-16 at 08:00, Harry wrote:
> Hi all,
>I install cygwin in my windows2000 so as to install postgresql. When
What data type did you use to define the binary column? bytea or LO?
On Thu, 2004-06-24 at 14:16, Eduardo S. Fontanetti wrote:
> How can I do to put a file into the PostgreSQL ? I
> have got the contents of file in binary yet and put on
> a String on my APP, but when I try to insert it on
> postg
I don't believe there is an option in pg_dump that current handles
that. It is the whole table / object or nothing at all. Depending on
the volume of transactions and frequency that you need to dump the data
will determine which solution works best for you.
Heavy volume and/or dumps multiple tim
Are you sure you have the raw database files? The /home directory is
not where they are normally installed by default...
If those really are the database files I believe you can try to
reinstall postgres following the normal installation instructions but do
not do the initdb step. Skip to starti
Only if Perl has been installed as an untrusted language I believe.
See http://www.postgresql.org/docs/7.4/static/plperl-trusted.html
On Fri, 2004-07-09 at 11:22, Haron, Charles wrote:
> Hello,
>
> I want to use Mail::Sender in a PL/Perl function. In order to use the
> Mail::Sender module, do
That could be a bug. How are you dumping the data? pg_dump? Select
query? How are you restoring the data? psql?
On Fri, 2004-07-09 at 09:16, Stef wrote:
> Oops, my button doesn't work...
>
> Hilary Forbes mentioned :
> => Can we go back to the beginning here?! If you are doing updates to
The best solution would be to fix the web app but
Could you set the deadlock_timeout in postgresql.conf? According to
documentation that will kill one of the transactions that has issued the
lock on the table or row?
On Fri, 2004-07-09 at 09:36, Konstantin Pelepelin wrote:
> Hi!
>
> In sit
Hello,
It is possible to enable the statements issued against the db to be
logged in postgresql.conf(log_statement = true). Depending on the OS
then you can filter the logs or maybe create a Perl script to scan the
logs.
HTH.
On Mon, 2004-07-12 at 10:08, Markus Bertheau wrote:
> Hi,
>
> I'd f
I believe you are correct. I will check my logs later. If you have access to the
code you could add individual sequences within each procedures and use those as
counters.
On Tue, Jul 13, 2004 at 10:07:33AM +0200, Markus Bertheau wrote:
> Ð ÐÑÑ, 13.07.2004, Ð 04:43, mike g ÐÐÑÐÑ:
> &
list. A patch would be welcomed as well.
Mike
On Tue, 2004-07-13 at 21:08, Markus Bertheau wrote:
> В Срд, 14.07.2004, в 03:35, Mike G пишет:
> > I believe you are correct. I will check my logs later. If you have
> > access to the code you could add individual sequen
Hi,
It is possible to vacuum each table individually. Perhaps vacuum the
large tables one a time first and then try a database vacuum.
Mike
On Mon, 2004-07-12 at 14:43, Octavio Alvarez Piza wrote:
> I have a database to which I re-create daily via ODBC. I only drop the
> data, not the index de
According to your posting below the second table will have all the
columns of the first table plus extra columns. If that is true then why
are you trying to add a column to your first table and not your second
table as well?
On Tue, 2004-07-13 at 06:32, evgeny tsurkin wrote:
> Hi All!
> That prob
What account is the postmaster service running under? Postgres or someother account?
What version of postgres and windows is this running on?
Mike
On Wed, Jul 21, 2004 at 09:14:05AM +0800, Howard Bagcat wrote:
> Anyone,
>
> I am troubled on logging on to my postgresql running under Cygwin. Post
There are but it depends if you are running under Solaris, Linux etc.
Most of the below can be checked with applications included with your
OS.
Mike
On Fri, 2004-07-23 at 06:23, Werner vd Merwe wrote:
> Good day all!
>
>
>
> I posted this question in NOVICE some time ago, but have not really
If you stop the postmaster service before copying the database directory
yes.
See http://www.postgresql.org/docs/7.4/static/backup-file.html
Mike
On Fri, 2004-07-23 at 07:24, Eduardo S. Fontanetti wrote:
> I have a question.
>
> I am getting trouble to dump my database with LO
> (Large Object),
Hello,
Did you remember to create your account in the database that you are
connecting to. Unless that database is a copy of the one you normally
connect to your user name won't exist in it.
Mike
On Thu, 2004-08-05 at 23:25, Senthil Jegadeesan wrote:
> I have to connect to a postgresql postmaste
24 matches
Mail list logo
