Dear Sir/Madam,
This is important and I need your help here.
I have taken a dump of my database from the old version of pg viz.8.1, using
pg_dump command. In the db I have a table with a column of datatype
'timestamp'. Now, when I try to restore it on the new pg version 8.3, the
datatype of the c
Hello,
I am creating an application in PHP that accesses a Postgres
database. This application works, but I have been unable to perform a
database task that is extremely important. My application is a admin
app that allows a user to insert records into several tables in a
database. The
Carol Walter написа:
> Hello,
>
> I am creating an application in PHP that accesses a Postgres database.
> This application works, but I have been unable to perform a database
> task that is extremely important. My application is a admin app that
> allows a user to insert records into several ta
Rajdeep Das writes:
> I have taken a dump of my database from the old version of pg viz.8.1, using
> pg_dump command. In the db I have a table with a column of datatype
> 'timestamp'. Now, when I try to restore it on the new pg version 8.3, the
> datatype of the column is getting altered to 'times
On Tue, Jun 30, 2009 at 1:13 AM, Rajdeep Das wrote:
> Dear Sir/Madam,
> This is important and I need your help here.
> I have taken a dump of my database from the old version of pg viz.8.1, using
> pg_dump command. In the db I have a table with a column of datatype
> 'timestamp'. Now, when I try to
Scott Marlowe writes:
> If I remember correctly, the sql standard says that timestamp, alone,
> means timestamp without timezone. But prior to 8.1 pgsql implemented
> timestamp as timestamp with timezone.
No, you're thinking of a change that happened in 7.3.
regards, tom
On Tue, Jun 30, 2009 at 8:45 AM, Tom Lane wrote:
> Scott Marlowe writes:
>> If I remember correctly, the sql standard says that timestamp, alone,
>> means timestamp without timezone. But prior to 8.1 pgsql implemented
>> timestamp as timestamp with timezone.
>
> No, you're thinking of a change th
Hello Pg Gurus,
I would like to know how can I configure PG clients in pg_hba.conf to
use DNS entries ( aka domain/host names) insted of ip's/CIDR-ADDRESS .
my env: PG version 8.3.6 on RHES 5.1
Thank you
Isabella
---
Isabella A. Ghiurea
Isabella Ghiurea wrote:
> Hello Pg Gurus,
> I would like to know how can I configure PG clients in pg_hba.conf to
> use DNS entries ( aka domain/host names) insted of ip's/CIDR-ADDRESS .
> my env: PG version 8.3.6 on RHES 5.1
> Thank you
> Isabella
>
Hello
You can not do this yet :(
It's an
Thanks for the response Richard.
We're trying to simulate rolling window concept in postgres with partitions,
without impacting application which does concurrent inserts into partitioned
tables. We basically need to roll off data from older partition say 7 days
older just to avoid the overhead
We used a rule that inserted into a partition mod the date.
Then we truncated the partitions before we reused them. This
allowed us to avoid changing the actual trigger. Here is the
trigger we are using for a two month rotation:
DECLARE
table_name text;
table_id_num int;
BEGIN
table_name
On Tue, Jun 30, 2009 at 11:45 AM, Richard
Broersma wrote:
> On Tue, Jun 30, 2009 at 10:26 AM, Bhella
> Paramjeet-PFCW67 wrote:
>
>> We're trying to simulate rolling window concept in postgres with partitions,
>> without impacting application which does concurrent inserts into partitioned
>> table
On Tue, Jun 30, 2009 at 10:26 AM, Bhella
Paramjeet-PFCW67 wrote:
> We're trying to simulate rolling window concept in postgres with partitions,
> without impacting application which does concurrent inserts into partitioned
> tables. We basically need to roll off data from older partition say 7 d
Hello PG Users,
I would like to know if there is a "clean" way to terminate running
and idle connections inside PG db ?
( I see : pg_cancel_backend (pid) will send the connections to idle
stage but not disconnecting from db , if you have > 100 idle
connections to db and don't want to use
>> I'm up to the challenge. I'll be adding a wiki page and slowly adding to
>> it. Thanks for the suggestion.
>>
I created the page "Installation and Administration best Practices".
I invite to all the interested people to add their suggestions.
--
Emanuel Calvo Franco
ArPUG [
#!/bin//bash
#
# Script: pgsession
# Author: Rao Kumar raoku...@netwolves.com
# Purpose: Utility to list/kill postgres database user sessions.
# Comments: Execute this script as "postgres" user (user who runs postmaster)
#
# INITIALIZE ENVIRONMENT
# Set up the environmental variables
#
KILL="kill
Plugge, Joe R. wrote:
> #!/bin//bash
> #
> # Script: pgsession
> # Author: Rao Kumar raoku...@netwolves.com
> # Purpose: Utility to list/kill postgres database user sessions.
> # Comments: Execute this script as "postgres" user (user who runs postmaster)
>
[]
Is it safe to kill pg ses
I've backed up my DB via 'pg_dump dbname' using no options. In order to restore
it via psql, do I first need to drop the db instance and recreate it?
Thanks in advance for your help.
-Mike
2009/6/30 Emanuel Calvo Franco :
>>> I'm up to the challenge. I'll be adding a wiki page and slowly adding to
>>> it. Thanks for the suggestion.
>>>
>
> I created the page "Installation and Administration best Practices".
>
> I invite to all the interested people to add their suggestions.
For al
On Tue, Jun 30, 2009 at 11:53 PM, Isabella Ghiurea <
isabella.ghiu...@nrc-cnrc.gc.ca> wrote:
> Hello PG Users,
> I would like to know if there is a "clean" way to terminate running and
> idle connections inside PG db ?
> ( I see : pg_cancel_backend (pid) will send the connections to idle stage
On Wed, Jul 1, 2009 at 12:59 AM, Mike angelo wrote:
> I've backed up my DB via 'pg_dump dbname' using no options. In order to
> restore it via psql, do I first need to drop the db instance and recreate
> it?
>
> Thanks in advance for your help.
>
> -Mike
>
> Hi Mike,
This is not the proper way t
> I've backed up my DB via 'pg_dump dbname' using no options. In order to
> restore it via psql, do I first need to drop the db instance and recreate
> it?
>
> Thanks in advance for your help.
>
> -Mike
>
>
>
yes, you have to drop the original db, then use psql -f to restore it.
--
Sent via pgsq
On Tue, Jun 30, 2009 at 11:26 PM, wrote:
> > I've backed up my DB via 'pg_dump dbname' using no options. In order to
> > restore it via psql, do I first need to drop the db instance and recreate
> > it?
> >
> > Thanks in advance for your help.
> >
> > -Mike
> >
> >
> >
> yes, you have to drop the
On Tue, Jun 30, 2009 at 5:20 AM, Kevin Kempter
wrote:
> Hi all;
>
> is it possible to see how much work_mem memory a particular session is
> using?
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mail
On Tue, Jun 30, 2009 at 9:36 PM, Scott Mead wrote:
>
>
>
> On Tue, Jun 30, 2009 at 11:26 PM, wrote:
>>
>> > I've backed up my DB via 'pg_dump dbname' using no options. In order to
>> > restore it via psql, do I first need to drop the db instance and
>> > recreate
>> > it?
>> >
>> > Thanks in advan
25 matches
Mail list logo
