there are ways of having postgres check and verify that files it expects to
find are there, and to get an idea on the extent of the damage.
On Fri, Oct 4, 2013 at 12:10 PM, Mike Broers wrote:
> Strange, this is happening in a totally different environment now too.
> The only
Strange, this is happening in a totally different environment now too. The
only thing these two environments share is a SAN, but I wouldnt think
something going on at the SAN level would make files disappear. Any
suggestions are greatly appreciated.
On Fri, Oct 4, 2013 at 9:40 AM, Mike Broers
Hello, our postgresql 9.2.4 qa database (thankfully its just qa) seems to
be hosed.
Starting at around 3:39am last night I started seeing errors about missing
files and now I cannot run a pgdump or a vacuum without it complaining
about files that it cannot find with errors like this: ERROR: could
I was recently asked how long it takes for postgres (or in my case
pgbouncer) to create a database connection and could not find a way within
postgres logging or psql to report this information.
I came across depesz's great article on pgbouncer utilizing tcpdump:
http://www.depesz.com/2012/12/02/w
Looks like psql> vacuum (verbose, analyze) is not reflecting in
pg_stat_user_tables as well in some cases. In this scenario I run the
command, it outputs all the deleted pages etc (unlike the vacuumdb -avz
analyze that seemed to be skipped in the log), but it does not update
pg_stat_user_tables.
On further review this particular server skipped from 9.2.2 to 9.2.4. This
is my most busy and downtime sensitive server and I was waiting on a
maintenance window to patch to 9.2.3 when 9.2.4 dropped and bumped up the
urgency. However, I have 3 other less busy production servers that were
all run
After patching to 9.2.4 I am noticing some mysterious behavior in my
nightly vacuumdb cron job.
I have been running vacuumdb -avz nightly for a while now, and have a
script that tells me the next day if all the tables in pg_stat_user_tables
have been vacuumed and analyzed in the last 24 hours.
Si
Wow thanks for the code!! I'll test it out and let you know if I get any
unexpected results.
On Wed, Nov 7, 2012 at 8:39 PM, Craig Ringer wrote:
> On 11/08/2012 04:42 AM, Mike Broers wrote:
>
> I would like to bump all sequences in a schema by a specified increment.
> Is th
has already done this kind of work or thinks its a wasteful pursuit for
some other reason I'm overlooking.
Thanks,
Mike
Ultimately the hosting service restored the files that they had not brought
over during their maintenance migration and we started up ok. So that was
a relief.
We had archived log files but it did not appear that the archive
destination was caught up with the xlog the cluster was complaining abou
that provides a better option.
On Sat, Jun 23, 2012 at 7:01 AM, Mike Broers wrote:
> Hello,
>
> We shut down our postgres 8.3 server last night cleanly for some hosted
> services maintenance. When we got our server back, it didnt have the
> pg_xlog mount with files and now wh
Hello,
We shut down our postgres 8.3 server last night cleanly for some hosted
services maintenance. When we got our server back, it didnt have the
pg_xlog mount with files and now when we start the server, it complains:
2012-06-23 06:06:04 CDT [18612]: [1-1] user=,db= LOG: database system was
filesystem at an 8k block size or problematic to leave it at 4k? I
have seen posts suggesting alignment of the postgres block size and the
file system block size and the raid block size, but wonder if a multiple is
sufficient or if it should match exactly.
Thank you
Mike
Should this be posted in performance instead?
On Fri, Jun 3, 2011 at 9:46 AM, Mike Broers wrote:
> I am in the process of implementing cascade on delete constraints
> retroactively on rather large tables so I can cleanly remove deprecated
> data. The problem is recreating some fo
I am in the process of implementing cascade on delete constraints
retroactively on rather large tables so I can cleanly remove deprecated
data. The problem is recreating some foreign key constraints on tables of
55 million rows+ was taking much longer than the maintenance window I had,
and now I a
I've seen various references to tools that
attempted this in the past but are now unmaintained. Is anyone aware
of any current tools or of the amount of work required to implement
such a tool?
Any help gratefully received,
Mike
--
Sent via pgsql-admin mailing list (pgsql-admin@postgres
g how this
number is not retreating after a database manual vacuum.
thanks,
Mike
e alter
table statement, or if there are any other dependencies or precautions I
should review before attempting this action? I have also seen there is a
workaround with running updates to the pg_attribute table but frankly that
makes me a little nervous.
Thanks in advance,
Mike
igger it on.
Thanks Alex, good to know I've not screwed up the kernel somehow.
I've been using 2.6.32 with grsecurity-2.1.14-2.6.32.9-201002231820 applied.
--
Mike Williams
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ference from
production is the kernel.
Test are para-virt VMs with "regular" kernels, production are real
machines with hardened kernels (grsec+pax).
I got prod onto a regular kernel and nothing in nearly an hour.
8.3.5 has worked forever and a day on this type of setup.
--
Mike Williams
On Sun, March 28, 2010 7:20 pm, Tom Lane wrote:
> Mike Williams writes:
>> ERROR: could not open segment 1 of relation 1663/743352/743420 (target
>> block
>> 2171336): No such file or directory
>> CONTEXT: SQL statement "SELECT day FROM min_stats WHERE day<= $
Y day DESC
LIMIT 1;
SELECT INTO day_for_update day
FROM min_stats
WHERE day<=last_day AND unique_ip=-1
ORDER BY day DESC
LIMIT 1;
Could anyone help us out here please?
Thanks
--
Mike Williams
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Is there a Postgres utility that allows data contained in a CSV file to be
loaded into the database?
are no other services (like
Apache) running on that machine. In your particular case I'd stick
closer to 1/4 side. Put that value in postgresql.conf.
Now, make kernel.shmmax slightly bigger than shared_buffers to
accommodate that value.
Cheers,
Mike
--
Sent via pgsql-admin mailing
://www.postgresql.org/docs/8.3/static/pgcrypto.html
Cheers,
Mike
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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
is? Or a pg_ctl option to stop recovering and shutdown?
Thanks
--
Mike Williams
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
In looking at SuSE's download site, I see two available RPMs: postgresql and
postgresql-server. It may be a novice question, but thn I am a Postgres novice.
What exactly is the difference?
/tmp/adempiere_`date
+%F`.dmp"
the result is a 49.5 MB file. Curious as to how the backup file can be less
than 1/10th the size of the database?
Thanks,
-Mike
system tables.
I'm assuming truncating a pg_toast table would be a bad thing...
Any help would be appreciated. Many thanks.
- Mike
little) or should I start drawing
up a different application design?
Thanks,
Mike
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
aracters, or to
easily locate them in a pg_dump file so they can be converted by hand?
Mike
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Tuesday 05 February 2008 11:04:07 Mike Williams wrote:
> Compiling postgresql non-hardened allows me to create any table I like, and
> throw a couple hundred meg of data and schema at it in one go.
Seems to be a problem specific to stack smashing protection.
If I compile with -fno
6dc26 in PostmasterMain (argc=3, argv=0x9b69e0) at
postmaster.c:966
#12 0x00529133 in main (argc=3, argv=0x9b69e0) at main.c:188
(gdb)
Means nothing to me...
--
Mike Williams
System Administration Manager - Comodo
Office Tel Europe: +44 (0) 161 8747070
Fax Europe: +44 (0) 161 8771767
---(end of broadcast)---
TIP 6: explain analyze is your friend
d kernel but the VMs dont (due to
the Xen and GRSec patches conflicting at the time of build).
--
Mike Williams
System Administration Manager - Comodo
Office Tel Europe: +44 (0) 161 8747070
Fax Europe: +44 (0) 161 8771767
---(end of broadcast)---
TI
roughly dense and missing the obvious? Am I'm doing something
stupid and un-supported? Or have I found a bug, perhaps?
Thanks
--
Mike Williams
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
32 pages
DETAIL: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.02u sec elapsed 0.02 sec.
(Hanging here for about 4 hours.)
Thanks,
Mike White
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I have a system that's been giving the nonstandard use of \\...' warning
in the postgresql log. Is there a way to get the SQL associated with
the warning without logging all the sql statements being processed?
---(end of broadcast)---
TIP 2: Don
On 10/8/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Mike C" <[EMAIL PROTECTED]> writes:
> > I have a corrupt database. I copied the database directory offsite and
> > restored from a backup. I'm now trying to recover data in the corrupt
> > database a
database and restored from backup). I guess the WAL files are
useless because of the vacuum I did used them all (or the recover
process from postgres itself)?
Regards,
Mike
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
some combination of the Binary String Functions
(http://www.postgresql.org/docs/current/static/functions-binarystring.html) to
process the file data.
Mike
On Wed, 2007-04-11 at 09:22 -0400, Alvaro Herrera wrote:
> Chris Hoover escribió:
> > No, I need to store the entire file as rec
Excellent! Thanks!
- Original Message
From: Paul Lambert <[EMAIL PROTECTED]>
To: Mike <[EMAIL PROTECTED]>
Cc: [email protected]
Sent: Saturday, February 24, 2007 4:09:03 PM
Subject: Re: [ADMIN] Lost password...
Mike wrote:
> Thanks for the tip.
>
> Cha
neusz Pluta <[EMAIL PROTECTED]>
To: Mike <[EMAIL PROTECTED]>
Cc: [email protected]
Sent: Saturday, February 24, 2007 12:46:53 AM
Subject: Re: [ADMIN] Lost password...
Mike napisał(a):
> Silly me - I installed 8.0 a year or so ago, and it is working just
> fine. When I went
n, and how do I remedy it?
TIA,
Mike
Now that's room service! Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097
hich already have set quotas.
>
>
>
>
> On Mon, 2006-11-06 at 16:52 -0500, Mike Goldner wrote:
> > On Mon, 2006-11-06 at 15:41 -0600, Nikola Radakovic wrote:
> > > Or, briefly how to set Postgresql user quota?
> > >
> > > On M
ply points to a filesystem
location. There is no "size" specified.
The size of the database is simply limited by the available filesystem
capacity (I suppose there may be some restrictions at the high-end).
Mike
On Mon, 2006-11-06 at 14:48 -0600, Nikola Radakovic wrote:
> Dear com
On Wed, 2006-10-25 at 15:54 -0400, Mike Goldner wrote:
> I have a nightly vacuum scheduled as follows:
>
> su - postgres -c "/usr/bin/vacuumdb --analyze --dbname=mydb"
>
> Last night, it appears that the vacuum blocked db access from my
> application server (JBoss).
8GB.
Is it possible that the extreme table size (maybe requiring the high
number of page slots) is causing postgres to block more than it should
in order to process that table?
Thanks,
Mike
---(end of broadcast)---
TIP 6: explain analyze is your friend
That works great, thank you!MikeOn 9/11/06, Aaron Bono <[EMAIL PROTECTED]> wrote:
On 9/10/06, Mike C <[EMAIL PROTECTED]
> wrote:
Hi,I'm trying to calculate an expiration date by adding the number of days onto the start date. i.e. select start_date + number_of_days from blah;
rator should support integers and treat them as days (
date '2001-09-28' + integer '7'). Obviously typing a constant into the query is a lot different from using the value of a column, but I would have thought it would work.What is the correct way to make this calculation?
Cheers,Mike
like to ensure that there has not been any data corruption
throughout the process i.e. if the restoration of the data is
successful, the data must not be corrupted, otherwise the d/r
solution is a failure.
I am running Mac OS X 10.3.9 and 10.4.4 and using PostgreSQL 8.1.2
Thanks,
Mike Lott
On 12/23/05, Simon Riggs <[EMAIL PROTECTED]> wrote:
On Fri, 2005-12-23 at 10:09 +1300, Mike C wrote:> On 12/22/05, Simon Riggs <[EMAIL PROTECTED]> wrote:> On Tue, 2005-12-13 at 11:18 +1300, Mike C wrote:
> > All the documentation I've seen for PITR poin
On 12/22/05, Simon Riggs <[EMAIL PROTECTED]> wrote:
On Tue, 2005-12-13 at 11:18 +1300, Mike C wrote:> All the documentation I've seen for PITR points to having to do a file> system copy of sorts.Yes. There's no other way, but why would you want another way?
Mainly because
es: http://www.postgresql.org/docs/8.1/interactive/sql-createindex.html
Could someone please clarify for me: Will I lose the INSERT statements performed while a CREATE INDEX is running?
Regards,
Mike C.
g the archived WAL
files into the xlog dir and creating a recovery.conf file?
Cheers,
Mike C.
these files with a single command, script or batch file.
Thanks,
--Mike
e the database size reliably
after a DELETE
and a VACUUM?
Note that I have also experimented with reltuples which does not give me
accurate results
either unless I run two VACUUMS in a row.
Please help.
Thank you,
Mike Samson
Senior Software Engineer
APC
---(end of broa
Hello. My name is Mike Cox. I am in charge of the changing of these
postgresql lists. I have decided that we are going to drop most of the
lists from the vote. We will only be making 4 lists into real Usenet
newsgroups if we win the election. The rest of the lists are crap and
they take up too
unsubscribe
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
banghe wrote:
One sql statement can solve this:
sql> isnert into table_b (id, name, summary) select id, name, desc
from table_a;
Banghe
Mike Darretta wrote:
Does anyone have a suggestion on the best way to migrate data between
two slightly different tables? For example:
Table A
from Table A into B,
using the desc column to populate the summary column.
Thanks,
Mike
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Thanks. I'll investigate and let you know how things go
Mike
Tom Lane wrote:
Mike Darretta <[EMAIL PROTECTED]> writes:
I'm an application developer trying to understand a pg data partition
issue. We are storing large objects (gifs) at a rate of about 1GIG /day.
After about
data partition is currently at 40Gig and
growing.
We are running Postgres 7.4 with the incremental vacuum process active.
Any thoughts?
Thanks,
Mike
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
http://www.aquadatastudio.com/
ADS is quite nice...been using it for a few months nowsupport for
oracle / db2 / sybase / mssql / postgresql / mysql ...it's written in
java with support for windows / linux / osx / solaris
On Mon, 2004-08-23 at 15:38, Keith Bottner wrote:
> Check out http://ems
or whether it
>receives an EOF indication and then quits.
I believe it's called truss on Solaris (but it has been a number of years
since I've been on such a box).
mrc
--
Mike Castle [EMAIL PROTECTED] www.netcom.com/~dalgoda/
We are all of us living in the shadow
-postgresql-7.3.6-1_ts2.eduserv_1.rhel3
rh-postgresql-python-7.3.6-1_ts2.eduserv_1.rhel3
rh-postgresql-pl-7.3.6-1_ts2.eduserv_1.rhel3
Any other suggestions?
Cheers
Mike
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: 09 August 2004 17:31
To: Mike
Tom,
Thanks for that.
It appears that the tcl support is there. However, the lib now appears
to be called:
./usr/lib/libpgtcl.so
Is this the same? I couldn't find documentation concerning the change in
file. If so then can I just edit the schema?
Cheers
Mike
-Original Message-
ever, when importing we get:
ERROR: stat failed on file '$libdir/pltcl': No such file or directory
What is the best way of sorting this out?
Cheers & TIA
Mike
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Hi,
I'd like to run psql on a remote machine. For security, there won't be
login access granted for ssh sessions but we'd like to test various SPs
and so forth. What is the minimum I have to install on to the remote
machine so that I can connect with psql -h remote
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 po
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
> (
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
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 und
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
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
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
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 ÐÐÑÐÑ:
> &
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
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
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
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
Jodi Kanter wrote:
> I am working with someone who uses MySQL and says that he has two
> separate databases in which he can query across. I am curious if that is
> something that can be done in postgres?
Postgresql implements SQL standard SCHEMAs which, depending on your exact
needs, may serve
Larry Rosenman wrote:
> [EMAIL PROTECTED] wrote:
>> i found the problem:
>>
>>
>>
>> sys=> create table test2(
>> sys(> id serial,
>> sys(> name varchar(10),
>> sys(> primary key(id)
>> sys(> );
>> NOTICE: CREATE TABLE will create implicit sequence "test2_id_seq"
>> for "serial" column "test2.
general list as well.
HTH.
Mike
On Wed, 2004-06-30 at 04:42, Debs wrote:
> I have a set of database files from PostgreSQL where the
> root partition crashed but the /home was saved. How do I remount
> these databases with a new installation of the O/S and database
> executables? N.B. I
rect
the results into a file.
Mike
On Wed, 2004-06-30 at 07:07, [EMAIL PROTECTED] wrote:
> Hi,
>
> I need to dump only partial content of my database, for example i want
> to dump only records that has been insterted to the database from a
> specific date.
> I tried to use pg_dump/
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
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
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
> &g
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
you can simply:
select * from pg_group;
On Thu, 2004-02-12 at 08:09, Eric wrote:
> In PostGres, we can show all existing users by "\du".
> However, how to show all existing groups?
> Thanks
>
> ---(end of broadcast)---
> TIP 6: Have you searched ou
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
helps you.
Mike
On Wed, 2004-05-26 at 10:25, [EMAIL PROTECTED] wrote:
> Thanks so much! :)
>
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 26, 2004 10:56 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL
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
ter
adding and restarting the system the above is all I get.
I tried specifying pgadmin to prefer SSL connection, and changed
pg_hba.conf entry to expect SSL from my VPN connection entry.
On Tue, 2004-05-25 at 08:42, [EMAIL PROTECTED] wrote:
> Thanks Mike!
>
> I already specified the
pg_hba.conf.
Mike
On Mon, May 24, 2004 at 01:02:12PM -0400, [EMAIL PROTECTED] wrote:
> Yes I can ping the server if not connected via VPN.
>
> I'm using EMS PostgreSQL Manager, which works if not via VPN.
>
> Yes, postgresql.conf's tcpip_socket = true.
>
> The
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
>
>
>
>
> _
Oleg,
Thanks for your suggestion but I'm not sure how this will help. The
function is created _after_ the tsearch installation (script below). I'm
backing up on one machine and trying to restore to another.
Cheers
Mike
#!/bin/bash
createdb cms
psql cms < /var/lib/
PostgreSQL 7.3.3 on i386-redhat-linux-gnu, compiled by GCC 2.96
I'm totallly stuck - I have seen pg postings which refer to droping and
re-creating SPs but I don't have the knowledge of tseach2 to understand
all the dependencies.
Hope someone can help!!
Cheers
Mike
't do me much good
(and I'm trying to restore some existing data). Ultimately want to move
them all up to 7.4.x
Any ideas as to what causes these errors? Anything I can do to fix the
output of pg_dump?
Thanks!
-Mike
_
MS
On Friday 31 October 2003 11:19 am, Marek Florianczyk wrote:
> W liście z pią, 31-10-2003, godz. 16:51, Mike Rylander pisze:
> > On Friday 31 October 2003 09:59 am, Marek Florianczyk wrote:
> > > W liście z pią, 31-10-2003, godz. 15:23, Tom Lane pisze:
> > > > Marek
1 - 100 of 153 matches
Mail list logo
